Good afternoon, I am a rookie when it comes to Macros. I believe I have a relatively simple one but am struggling to get it done.
I have an excel sheet with unique identifiers in Column B. The problem I need that Unique identifier Copied and pasted down Column B until I reach the next unique identifier in Column B and continued down the entire sheet. Some might have 20 spaces between, some might have one. This goes on for 59000 rows and I would like to have them populated accordingly if possible? Can anyone help? Let me know ASAP.
Thanks!
I have an excel sheet with unique identifiers in Column B. The problem I need that Unique identifier Copied and pasted down Column B until I reach the next unique identifier in Column B and continued down the entire sheet. Some might have 20 spaces between, some might have one. This goes on for 59000 rows and I would like to have them populated accordingly if possible? Can anyone help? Let me know ASAP.
Thanks!