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.

"JCS" wrote:

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" wrote:

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.