Linking 2 worksheets

[Paul]

I have a workbook with 4 worksheets.
Each worksheet contains a section with formulas summarising the data on that
worksheet.

I'd like to copy these summary tables onto a 5th sheet so they can be read
easily. If possible I'd like to maintain the formulas so that if I make a
change to the data on sheet 1 it is updated in the summary on sheet 5.

Any help would be much appreciated.

Paul

 

[belvy123]

Hi Paul

Try this

in the cell on the new sheet where you want to have your data
enter " = " then click on the tab for the sheet where the data
will come from and then click on the cell where the data is located at and
then hit enter.

Continue this for each sheet and cell you have the need for

Hope this helps

 

[Gord Dibben]

From each sheet in turn, Copy>Paste Special>Paste Links>OK>Esc onto Sheet5


Gord Dibben MS Excel MVP