ms excel courses - master workbook and copying

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

resolvedResolved · Low Priority · Version Standard

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Pivot table grouping

If 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.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

View all Excel hints and tips


Server loaded in 0.09 secs.