Number sequence column B if a condition is met in column A

[MICowboy13]

Hello all,

Please See Attached

I would like to find all of the rows that have "1000" in column A and sequentially number column B for these rows. So the 1st row with "1000" in column A will replace "000" and show "001" in column B of that row. Next "1000", "002". Next "1000", "003" and so on. The "1000" Number can also be found in cell A7 of the spreadsheet. i would like to start with the following code.

Please Login or Register  to view this content.

I need help to finish the code. The "xxx" would be the part to change, as I need the Cells(p, "B") to be sequentially numbered (ex. 001, 002, 003)


Thanks in advance.

[natefarm]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.