Fill Series of Sequential Numbers in Column A Based on Last Value in Column B - VBA

This should be fairly straight forward, but I am having a tough time getting it figured out. I simply want to insert a blank Column A and then fill in Column A with a series of sequential numbers all the way down until the last value in Column B.

Here is what I have so far...

Please Login or Register  to view this content.

See example spreadsheet for clarification. Notice cell B2 will always be blank so we need to make sure we are using the .End(xlUp).Row function to make sure the code isn't stopping at cell B2 and is capturing the entire range of Column B.

Beautiful! Worked great! Thanks a lot!

Hi cc268

this will insert a '1' into cell A3, next to your PartNumber1 then copy down sequentially to the last entry in colum B

hope this is what you are looking for

Please Login or Register  to view this content.