Somewhat hard to explain, but I have a list of names that I need to duplicate 5 times. So, for example, I need to turn this...
Name
Abe Lincoln
George Washington
George Bush
Richard Nixon
Into this...
Name
Abe Lincoln
Abe Lincoln
Abe Lincoln
Abe Lincoln
Abe Lincoln
George Washington
George Washington
George Washington
George Washington
George Washington
George Bush
George Bush
George Bush
George Bush
George Bush
Richard Nixon
Richard Nixon
Richard Nixon
Richard Nixon
Richard Nixon
The code must be simple, but I'm still fairly new to VBA...
Thanks,
Eric
Bookmarks