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?

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.

Eliz@officeformac.com wrote:
> 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 M. Jones, C.E.T.    "If it's Fixed, Don't Break it"
http://www.phillipmjones.net           http://www.vpea.org
mailto:pjones1@kimbanet.com