Run a macro to place sequential numbers at each row in a range

Hi everyone,

I am looking to add sequential numbers to a data set, however i would only want the number to increase each time a blank row was located.

eg.

Row 1 Yes 000001
Row 2 Yes 000001
Row 3 Yes 000001
Row 4
Row 5 Yes 000002
Row 6 Yes 000002

The number of rows between each gap is not predetermined.

Please see the attached example doc for the desired outcome.

Any assistance would be much appreciated. I have upwards of 500,000 rows to work through so a macro to process the data would be a GREAT advantage.

Thank you in advance.

Please Login or Register  to view this content.

Hi Ethanrholt,
try this

Please Login or Register  to view this content.

Hey there,
This should do what you want:

Please Login or Register  to view this content.

I've attached the one you sent - it's currently set to run the macro if you press Ctrl + Shift + I, but if you put that code in any module and run it it should work.
Example.xlsm

EDIT: nilem's is probably more reliable. He is a forum expert after all XD

Brilliant!

Thank you all for your quick responses. Having checked each suggestion they all seem to work perfectly.
Trying my best to learn VBA as i go but not always quite sure what method is best to use. I'll get there eventually with help from Excel forum.

Thanks again all. Have a great day.