Placing a Workbook inside a workbook
I have 4 separate workbooks that I use to collect data from 4 different shifts. Can I place these 4 workbooks into 1? basically open said workbook and it have 4 tabs in it. Each tab opens to the needed 33 worksheets for the individual shift. I have these 4 work books linked to a totals summary worksheet in a 5th workbook. I am trying to reduce clutter and clean up a bit.
Hi Marsh,
Welcome to the Forum!
Yes, you can do that - you could stack them vertically and have just the 34 sheets or you could have all sheets in one book
They'd have to be distinguishable - so some sort of naming to differentiate them
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
XLAdept,
Just how would I go about stacking them?
These are the workbooks I am dealing with. A,B,C and D shifts. The information from them is totaled in the Monthly Totals.
I'll respond to this tomorrow, lest someone intercede
Copy that. Thank you sir.
Hi Marsh,
This looks to be fairly complicated - not the least of the complications is that you sent me protected sheets and no password
Sorry about that. for the 4 shifts, the password is DAR. For the Totals Page, the password is DARTOTALS
You may not want to do this, to get this far I had to delete all the named ranges. If you do want it, I've still got more coding to do. The only data I noticed was in Shift D on the first:
I ran the Shift sheets one at a time to create the Stack tab in the master and I created the TotiN tab because of the password hassle.
And- Thanks for the rep!
Please Login or Register to view this content.
Last edited by xladept; 04-02-2016 at 10:45 PM.
This will be used by each shift, 7 days straight for A shift, 7 nights straight for B shift. Then C and D take over. I am just trying to have less folders/files. Clean it up a bit you might say
Well, is it what you wanted? Is it worth the named ranges? Look it over and let me know
I am about to play with it and see how it goes. Thank you for the assistance!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks