changes to master copy of worksheetautomatically updates a copy in another location

[Eliz]

Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Hoping to make copies of worksheets that will update automatically when worksheets in the master set are modified. Is that possible? Would one do it by linking the whole sheet?

 

[Phillip Jones, C.E.T.]

I had to do something similar to this, this summer when my mother was in
nursing home and I had to pay here bills.

I had to put information in a given cell on page of the next succeeding
sheet:

this is but one example: =SUM(Sheet1!F19). Note the ! is not a mistake.
If not in there it won't work.

you have to do that for each instance need. The reference to f19 (could
be any cell) is the exact cell you are copying from. if you make a
correction to the same cell in sheet 1, the each succeeding page that
has that reference will change as well.