98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel courses - Master workbook and copying data
ms excel courses - Master workbook and copying data
Resolved · Low Priority · Version Standard
Tue 19 Jun 2007, 15:17Delegate Vicki said...
Vicki has attended:
Excel Advanced course
Master workbook and copying data
I have a collection of workbooks (each workbook = 1 period sheet and 4 week sheets, all linked * 13 books per person * 13 persons - HUGE). They are timesheets.
What I would like to do is create a master workbook to hold the main data so all I would need to do for each project is change the master book and it would automatically populate all the other workbooks. Is this possible or do I have to do each workbook of each period and each person as I do at the moment?
I am sure there must be a way to connect them all - I just haven't worked it out yet.
Vicki
Tue 19 Jun 2007, 16:39Trainer Richard said...
RE: master workbook and copying data
Hi Vicki
I get the basic setup of what you are tying to do, but not clear on when you say the MAIN DATA.
When you setup the worksheets, how are they linked together? What changes are you making when you setup the sheets?
regards
Richard
Wed 20 Jun 2007, 07:58Delegate Vicki said...
RE: master workbook and copying data
What I am trying to achieve is to have one sheet that I can enter any new project data which will then feed all the rest to save me having to input on every sheet (845 of them). Things like the project title and the items down the side of the sheet that we allocate time to.
Within each workbook there are 4 weeks and a period sheet. I have linked the sheets by =then the sheet and cell, which works fine. I have also linked all the period sheets to a separate valuation sheet with formulae to calculate the hours * the hourly rate which also works fine. What I am struggling with is a quick way to set the period sheets to look at this single entry data sheet. Ot is the only way to go into every cell and identify it with a link?
If it would help I could try to send you one workbook and the main sheet to have a look at. I have also subsequently decided that there needs to be an interim sheet for the individual so their personal information can be added so now there is a main sheet, a personal main sheet and 13 workbooks containing the timesheets for each of the 13 people.
Sorry it's a bit complicated - well it's not really but difficult to explain without seeing it
Regards
Vicki
Thu 5 Jul 2007, 08:59Delegate Vicki said...
RE: master workbook and copying data
I have still not yet had a reply to my post. Are you still looking at it or can it not be solved?
Tue 17 Jul 2007, 12:50Trainer Rich said...
RE: master workbook and copying data
Vicki,
Sorry for the delay. Richard is on holiday at the moment and returns next week.
Meanwhile, you can e-mail the example worksheet to forum AT stl-training.co.uk and I will have a look myself. If I can't come up with a solution (I'm a Dreamweaver trainer!) I'll pass it on to Richard as soon as he arrives back to the office.
Regards, Rich
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Pivot table groupingIf you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other. |
