Possible to have multiple sheets refer to a master template sheet?

[reznor9]

I have a worksheet which summarizes and calculates the activities of
employees.
It does this with 9 identical sheets(one per employee) and one summar
sheet which has all the employees total number of hours spent in certai
functions summed together.

Now currently when I have to make changes like adding fields, I make th
changes to one employee sheet, then I manually copy the entire sheet, g
to the next employee sheet, select all, paste, then I have to manuall
make a change to personal items in the page such as the employees nam
and days off. This has to be done to all 8 sheets, and is a sligh
inconvenience.

Now my question is, can I instead create a master template page in whic
the others draw from so I only have to make changes to the maste
template, thus automatically reflecting the changes to all correspondin
sheets?

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

Thank

 

[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