Macro to create new excel when last row is filledClosed

Question

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

TrowaD · Answer

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

jegan_venkat · Answer

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

TrowaD · Answer

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

jegan_venkat · Answer

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

TrowaD · Answer

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.

Macro to create new excel when last row is filled

5 responses

Similar discussions

Subscribe To Our Newsletter!