Hi Guys,
Thanks for the help in advance, still learning how to do loops. I need help building a macro that loops.
What I am trying to accomplish;
I need to built a macro that will loop through cells D3:AQ101
If the cell is blank just move to the next cell, if there is data present I need the macro to copy that piece of data into the “macro sheet” and paste it under ID.
I also need the macro to copy the associated “name” from column B to correspond to copied data cell and paste it in the macro sheet in column B
Example: If there is data in cell D6 “922126” and data in B6 “John Doe 4” in the list it should read:
The macro would run for all data in the selected range and create this list.
Thanks so much for the help guys!
Bookmarks