Hello,
I'm a fairly low-level noob, but with the help of this forum have been able to do (seemingly) alot. Here is what I'm currently trying to do: I am trying to copy the second sheet of six different workbooks into a single workbook and pasting them into sheets 1-6 in my new workbook. I've used a similar process before, but the code seems exceptionally long to me. I believe there must be a way to loop or something else I'm not aware of to avoid writing the code six times (i.e. for each copy and paste). Here is what I have so far:
..... [I do think from "Otherbooks" 3,4,5,and 6. Any suggestions on how to make this less redundant would be appreciated.
Bookmarks