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?

I ask because in the future I may have to do this for 100+ employees and seems a daunting task if I were to have to make a small change as I don't wish to paste something 100+ times.

Thanks

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?