Fill sequential number down empty column, save last number, use as first number next time

You can get the last row in a column by using this formula. Change the "A1" to the column you want the last row for.

Please Login or Register  to view this content.

To fill to the last row, you can use something like this. LastRow below would be the larger of last row for A or C

Please Login or Register  to view this content.

Hope this helps

Thanks, I see what how that works. However, I am afraid I don't see how to add it to the original code to make the original code fill the sequential number to the end, and then save the last sequential number? I guess there is only so far "Google University" can take you in programming

I'm not sure of the results of your original code, however I think that this is what the code should look like

Please Login or Register  to view this content.

Thanks for the extra work! Unfortunately, I can't get it to work. Maybe the files will help. I attach five files here for your review.

1. Source.xlsm
2. LeadNumberMaster.txt
3. Three output files parsed out and saved by Client name and data.

As you can see the Numbering macro does increment and number the first line of data, but not all the lines of data.

The Parse macro does extract data by Client and save the files.

I hope these help. You may want adjust paths for files before trying them.

Thank you for your response, experties and assistance!

Bob

So you want column B in Source.xlsm incremented? When, before or after, the split?
Which macro gets executed first? Sub Lead_Number() or Sub Parse_Dealer_Files()?

Originally Posted by hectop

So you want column B in Source.xlsm incremented? When, before or after, the split?
Which macro gets executed first? Sub Lead_Number() or Sub Parse_Dealer_Files()?

Thanks for the response. Sorry I was traveling and away from email.

Filling the incremental number sequence would occur first.

I usually write them as separate macros and then call them in the order I want from a main macro. It seems easier to me to maintain and test individual macros than one huge one.

But either way is fine!

Thanks again for filling in for my lack of knowledge.
Bob

This should do it.
Source.xlsm

Originally Posted by hectop

This should do it.
Attachment 274378

Thank you so much. It works like a charm ...... until about 32809
at which time it throws off a "stack overflow" error. I don't see a reason for it to care that the number gets that big?

Any ideas?

Thanks again for all the help!

Bob

Maximum integer range is -32,768 to 32,767.
Change the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

This converts it a Long variable which has a range of -2,147,483,648 to 2,147,483,647.

As they used to say in Chicago... "You da Man!". Works perfectly. Thanks so much for getting that working for me.
Bob