Have worksheet changes cascade down?

[Jeremy]

Hello. I have a workbook in Excel 2007 that is made up of three different
worksheets. I want to copy those three worksheets so there are a total of
four sets of the three worksheets. I know how to do that, but when I make a
change to the content of the original three sheets, I want that change to
cascade down the other three identical pages.

For example...we're using the worksheet to track harness uasage for several
individuals, over a four week period. If I change on of the individuals names
on the first sheet of the three sheet set, I want that change to cascade to
the first sheet of the three following sets. I understand that if add
something to the first sheet, it will fill in the same cell on the following
sheets, but I need to change some of the copied data and have it update in
the corresponding sheets after.

Thanks for any input.

 

[Spiky]

Are the secondary sheets going to remain identical to the parent or do
just certain cells transfer over?

 

[Jeremy]

There are three different sheets and I need to copy them exactly so I have
four exact duplicates of the original three. What happens... we have
performers that are all assigned harnesses. These performers have contracts
of varying lengths. When one performer leaves or we get a new performer, I
want to be able to add that performer (or remove) on the first three sheets
and have that change "cascade" down to the other three sets of sheets. The
sheets are to track the usage of the harnesses and that a technician has
inspected them and the performer has then inspected them.

Does that help? Thanks.

 

[Pete_UK]

You can copy a sheet into the same workbook just by CTRL-dragging the
sheet tab, do this three times for each of your sheets and you will
have your 4 sets of copied sheets - you may want to rename them
appropriately.

If you group some sheets together, then any change that you make on
one sheet will be reflected on all the sheets. So, if you want to make
changes to Sheet1 and its copies, select the sheet and then hold down
the CTRL key while you click on the other sheets that were copied from
it. Make whatever changes you need to, then click on one of the other
sheet tabs to ungroup the sheets, or right-click on one of the grouped
sheet tabs and click Ungroup sheets from the drop-down.

Use this method whenever you need to change something in all 4 copies
of a sheet.

Hope this helps.

Pete

 

[Jeremy]

Yeah, I knew that. I was hoping there was an easier way as we don't have the
brightest tools in the shed (lol) updating the sheets.

 

[Pete_UK]

Okay then, instead of copying the original sheets you can set a new
one up for each sheet by putting this formula in A1 of a new sheet:

=IF(Sheet1!A1="","",Sheet1!A1)

and copy this formula across and down as required to cover the
information in Sheet1. Then you can apply any formatting from Sheet1
to this new sheet so that it looks the same, and then you can copy the
new sheet twice. Do this for the 2 other original sheets, changing the
sheet name as appropriate.

This way you will not have to group the sheets together, but any
changes in values on the original sheets will be reflected
automatically. However, if you delete or add a row to the original
sheet then the copies will not reflect this.

Hope this helps.

Pete

 

[Jeremy]

That sounds like the ticket. I'll try it as soon as I get home and let you
know. Thanks!

 

[Pete_UK]

You're welcome.

Pete

 

[Jeremy]

Pete, you are an Excel god to me!

It worked perfectly!

Thanks you so much!