Linking Spreadsheets within a workbook

K

Kathy

I would like to link individual spreadsheets to a masterspreadsheet within a
workbook. Can someone help me not only link the data but also the format of
the cell. Example if the cells are different colors for different reasons -
how do I move over the colors?
 
R

Richard O. Neville

I would start by copying one of the individual sheets, renaming it "Master."
It will contain data that you can delete, but you will retain the colors and
formats. To cumulate the individual sheets into the master, start with the
uppermost and leftmost cell to be cumulated. Type = , then switch to each
individual sheet in turn, clicking on the cell with the same address. So
your Master sheet formula might look like this when cumulating cell B3:

='Sheet1'!B3+'Sheet2'!B3+ . . .etc. etc. No + needed after the last
entry.The drag the formula across and down the Master sheet to take in all
the cells.
 
K

Kathy

Thanks for the suggestion - but that is not working for me. I want to be
able to make changes on the individual worksheet and it automatically update
the master to the correct colors. Any more advise??
 
Top