Is it possible to create a master Worksheet

[Kim]

I have a excel sheet that I use for all 60 different people. Each prson has
their own workbook and each workbook contains 12 tabs with this excel sheet.
If I need to add columns or rows to the sheet it takes forever because I have
to go into all 60 workbooks and make the changes individually on all the 12
tabs in each workbook.

I am wondering if it is possible to create one master worksheet that I could
make additions or deletions to and have it apply the changes to all the other
worksheets without me having to go into everyone of them on an individual
basis to do so. Does that make sense? Any guidance you could give me would
be greatly appreciated.

 

[Luke M]

Simply setup all the other workbooks to link directly to your Master workbook.

Step by step:
1. Open master workbook & coworker's workbook.
2. In A1, start typing "="
3. while still typing formula, select your master workbook, master sheet,
and select cell A1
4. Formula should now look something like:
=['Book1.xls]Sheet1'!A1
5. Copy this formula over entire sheet (or as large as you feel is necessary)
6. Save & close.

Then, copy this linked sheet from the one coworkers workbook to all the rest
of the workbooks.

 

[JCS]

Kim,

If I understand your requirement, all you need to do is to:
1. Select all of the tabs by holding down the Shift key and then selecting
each tab.
2. Make you changes

This should do it.

John

 

[JCS]

Kim,

In my last reply, I forgot to mention that you only have to make changes to
any one of the spreadsheets that have been selected and the change will be
made to the others.

John

 

[Kim]

I have several different files that all use the same spreadsheet. The data
that is entered into each one is different but the formating is the sames and
the required data being entered is the same. I just want to be able to
change the formating on one spread and have the changes made on all of the
other spreadsheets without me having to do it one sheet at a time. I also
don't want the data that has already been entered to change either. Does
that make sense.