Linking 2 worksheets
 

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

Linking 2 worksheets
 

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
--
crunchin numbers


"Paul" wrote:

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

Linking 2 worksheets
 

From each sheet in turn, CopyPaste SpecialPaste LinksOKEsc onto Sheet5


Gord Dibben MS Excel MVP

On Sat, 31 May 2008 18:58:00 -0700, Paul wrote:

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