Hi,
I am looking to combine (3) Worksheets from different Workbooks onto one Master Sheet.
I would be looking to combine the "Combined Shedule" Worksheet on all (3) attached Workbooks to create (1) Master Schedule.
All of the workbooks would reside in the same folder (the folder also has other workbooks in as well).
Hoping someone can help?
Thank you!
Sandi
Last edited by ssteines; 10-21-2011 at 12:03 PM.
What's the problem? If you just need to combine the values, copy each sheet and paste it to the bottom of one of them.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Would like to try and automate to combine the sheets. So they would refresh automatically as the data is constantly changing. Would some how like to add a refresh button that would sum the top lines on the Combined Schedule and then loop through the data below to update / add / delete lines as necessary, finishing with a total at the bottom?
Hope this makes sense?
I'd suggest creating a worksheet that is linked to all 3 other sheets. Use the top third for one sheet, the next third for the second, etc. Then you can sort the new sheet to keep all the data on top.
Not sure if that is what I am looking for but will look into.
Thank you,
Sandi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks