Quote:
Originally Posted by Claus Busch
Hi,
Am Sun, 24 Mar 2013 19:28:42 +0000 schrieb reznor9:
I have a worksheet which summarizes and calculates the activities of 9
employees.
It does this with 9 identical sheets(one per employee) and one summary
sheet which has all the employees total number of hours spent in certain
functions summed together.
Now currently when I have to make changes like adding fields, I make the
changes to one employee sheet, then I manually copy the entire sheet, go
to the next employee sheet, select all, paste, then I have to manually
make a change to personal items in the page such as the employees name
and days off. This has to be done to all 8 sheets, and is a slight
inconvenience.
Now my question is, can I instead create a master template page in which
the others draw from so I only have to make changes to the master
template, thus automatically reflecting the changes to all corresponding
sheets?
you can group the 9 sheets: Click on sheet1 and then with pressed shift
button the last of the 9 sheets. Now your changes will be made on all
grouped sheets.
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
Hai CB,Thanks a lot for that suggestion . i was really looking for this kind of suggestion. i have been doing all the formatting with every sheet. i didn't know about this grouping . now if i want that common changes should not affect a particular sheet in the group, i have to ungroup a sheet , for that, what should i do?
Similar Threads
Threaded Mode
