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
Hi,

The data will be automatically filled in my excel sheet and it will be more than 1500 rows. now i want a macro that automatically create a new Excel and makes the continuation of filling the data [ that is after 1500-th row] must be filled in that new excel sheet.

Anyone knows.., plz help me.....

Thanks

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
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
1
jegan_venkat Posts 4 Registration date Tuesday August 6, 2013 Status Member Last seen August 12, 2013
Aug 7, 2013 at 12:30 AM
Hi Trowa,

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
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Aug 8, 2013 at 10:56 AM
Hi Jegan_venkat,

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
0
jegan_venkat Posts 4 Registration date Tuesday August 6, 2013 Status Member Last seen August 12, 2013
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
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
0
jegan_venkat Posts 4 Registration date Tuesday August 6, 2013 Status Member Last seen August 12, 2013
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
0

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
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.
0