Hello-
I cobbled together this code to copy data from another opened workbook and paste it onto a different workbook exactly where I want it to. It works great but I am having a hard time figuring out how to repeat (maybe loop) it without simply pasting it 20 times and manually updating it.
I need the subroutine to loop and instead of using my dimensional variable "Hilton1" to use "Hilton2", and then use "Hilton3" and so on. Thanks for your time.
Please Login or Register to view this content.
Bookmarks