Macro to create new excel when last row is filled
Closed
jegan_venkat
Posts
4
Registration date
Tuesday August 6, 2013
Status
Member
Last seen
August 12, 2013
-
Aug 6, 2013 at 12:29 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 13, 2013 at 10:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 13, 2013 at 10:50 AM
Related:
- Macro to create new excel when last row is filled
- Create skype account with gmail - Guide
- Create new instagram account without phone number - Guide
- Spell number in excel without macro - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Saints row 2 cheats - Guide
5 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 6, 2013 at 10:31 AM
Aug 6, 2013 at 10:31 AM
Hi jegan_venkat,
Not entirely clear.
Do you mean that when you keep receiving rows, your sheet will eventually reach it's limit, thus continuing on the next sheet?
Or do you mean that you want to put every batch of x (1500?) number of rows to be put in it's own sheet?
Or did I get the wrong idea?
Best regards,
Trowa
Not entirely clear.
Do you mean that when you keep receiving rows, your sheet will eventually reach it's limit, thus continuing on the next sheet?
Or do you mean that you want to put every batch of x (1500?) number of rows to be put in it's own sheet?
Or did I get the wrong idea?
Best regards,
Trowa
jegan_venkat
Posts
4
Registration date
Tuesday August 6, 2013
Status
Member
Last seen
August 12, 2013
Aug 11, 2013 at 11:41 PM
Aug 11, 2013 at 11:41 PM
Sorry for late reply...,
The incoming data is from a different program and that program is a VB based software that exports numeric data [ readings ]....
Waiting 4 ur reply...
Regards
~Jegan_Venkat
The incoming data is from a different program and that program is a VB based software that exports numeric data [ readings ]....
Waiting 4 ur reply...
Regards
~Jegan_Venkat
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 12, 2013 at 10:30 AM
Aug 12, 2013 at 10:30 AM
Hi Jegan_Venkat,
It's the code from the VB based software that copies your data. I would like to see that code so I can hopefully change it to do as you want.
I say hopefully since I can't test the code 'cause I don't have that VB based software.
Best regards,
Trowa
It's the code from the VB based software that copies your data. I would like to see that code so I can hopefully change it to do as you want.
I say hopefully since I can't test the code 'cause I don't have that VB based software.
Best regards,
Trowa
jegan_venkat
Posts
4
Registration date
Tuesday August 6, 2013
Status
Member
Last seen
August 12, 2013
Aug 12, 2013 at 11:27 PM
Aug 12, 2013 at 11:27 PM
Sorry .., I don't have the back up of that VB software. Its installed on my system...
The VB software just exports the data to excel format.....
Please Help me.....
Regards
~Jegan_venkat
The VB software just exports the data to excel format.....
Please Help me.....
Regards
~Jegan_venkat
Didn't find the answer you are looking for?
Ask a question
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 13, 2013 at 10:50 AM
Aug 13, 2013 at 10:50 AM
You are not making it easy to help you.
If you code puts data in the first sheet of Excel file, we could let Excel know that when a certain number of rows is exceeded, create new sheet and make that the first sheet.
Or is your data copied to a specific sheet?
Do you open Excel after every data export?
Is the exported data always the same size?
Just some questions that came to mind.
If you code puts data in the first sheet of Excel file, we could let Excel know that when a certain number of rows is exceeded, create new sheet and make that the first sheet.
Or is your data copied to a specific sheet?
Do you open Excel after every data export?
Is the exported data always the same size?
Just some questions that came to mind.
Aug 7, 2013 at 12:30 AM
Thanks for ur reply.....
and my doubt is,
My sheet will eventually reach it's limit, thus continuing on the next sheet or new workbook....
Regards
~Jegan_venkat
Aug 8, 2013 at 10:56 AM
You say that "data will be automatically filled in my excel sheet".
Where is that data coming from? Another Excel file or a different program?
What code are you using to automatically fill your sheet?
Best regards,
Trowa