How to find a number in a string and copy it to the cell below while adding 1 to it

[GreenTee]

Hello,

I'm trying to figure out how to find the last two numbers in a cell in column A and copy that cell to the cell below it while incrementing the last two numbers by one.

I wrote a noobish code that creates the values in column A as ID in increments of 10. However, there's another code that runs AFTER the ID has been created which inserts rows below it. To which I'll need to go back and search for the blank rows below the previously created ID's and populate the same ID but incrementing by one.

Here's the sample workbook.
Incrementing.xlsm

Any help would be greatly appreciated.

Thanks in advance.

[Arkadi]

Hi GreenTee,

Assuming that your ID will always have only one _ and that it will be just before the number, replace your SplitCellToNewRows with this version, that i have modified to put the numbers in while it copies:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[GreenTee]

Hi GreenTee,

Assuming that your ID will always have only one _ and that it will be just before the number, replace your SplitCellToNewRows with this version, that i have modified to put the numbers in while it copies:

Please Login or Register  to view this content.

wow this is awesome!!!

this works as I described it

However, one little change.. is there anyway I can make the incrementing by one as a separate macro? I didn't want it to run all at once just in case I manually wanted to enter extra rows. So the ID incrementing by one would have to be a separate macro.

[GreenTee]

Maybe:

Please Login or Register  to view this content.

Sorry John.. this wasn't working for me. I tried running it, but it just didn't do anything.

[Arkadi]

GreenTee,

So forget what i sent, and use your original macros. After yours are done, run this one:

Please Login or Register  to view this content.

[GreenTee]

that works perfectly!!

Thanks a ton!

[Arkadi]

Glad it helped!