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
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
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
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?
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
