Hi All,
This request seems pretty simple, I actually cannot believe that something similar hasn't already been done online! Hopefully, someone can help me. Struggling with Macros and VBA so thank you in advance! Please could you write literally everything I would need to paste into the Module?!
I just need to populate Column A with consecutive numbers as follows WITH a blank row in between each number. I would MANUALLY enter 1.00 so the Macro would populate the numbers following this, ie. from 1.01 inclusive. If I entered 2.00 instead of 1.00, the numbering would start from there, so the next number the Macro would need to spit out would be 2.01, then 2.02... Same if I entered 3.00 or 4.00 etc etc.
1.00
1.01
1.02
1.03
1.04
... etc etc. The ending number will be unknown but not large (ie, not a great number of rows), so ideally, the Macro would spit out blocks of 5 numbers at a time. Ie. When I run the Macro, it does...
1.01
1.02
1.03
1.04
1.05
Then every time I run the Macro as required, I could add the next 5 numbers in the sequence. So the second run of the Macro would spit out...
1.06
1.07
1.08
1.09
1.10
Remember... there needs to be a blank row inserted between each number.
I can't imagine this is complex code for you guys to create?! Again, Many thanks.
Bookmarks