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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 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 replies

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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