Hey folks!
I could use a nudge in the right direction here. I have a large document at work that houses a range of values for numerous users, and then separate documents for each user that they fill in themselves. Every week, I have to open the user doc, copy a range of cells, paste into their respective range, and repeat that process for ALL users. It's time consuming and frustrating since I'm sure there's a more automatic way to set this up.
I found some VBA code that'd allow me to copy a range from an open workbook, but I'd like to skip the open workbook part since it sort of defeats the purpose. Additionally, the VBA code I found only allows for one range on one workbook to be copied, where I'd actually need to copy a range from multiple workbooks. So for example:
The main document is saved out by week. The user documents are saved out by month. I'd like to have some code on the main workbook via a macro I can set up to go look at User1's workbook (closed, though), and copy cells A2:F23 and then paste them into cells A1:F22 on the main document. Then, before completing, it would go to User2's workbook, and do the same thing, only paste into cells A21:F42. Then User 3, User 4, etc. etc.
Is there ANY way to do this?
I've attached an example worksheet. Tab 1 is how the individual user documents are set up, and tab 2 is how the main document is set up (you'll notice on tab 2 there are different users, but each week range is the same).
Any help would be greatly appreciated, and if you need more info, just ask! Thanks!
Bookmarks