Automatically updating data between worksheets.

[Gunnar Boykin]

Hello,

I've had this problem for a while, and I know that there has to be a very
simple solution for it, so here it is.

I have a workbook with multiple worksheets. The first sheet is a totals
page, which shows the calculated data from all of the sheets in the workbook.
How do get the cells in my "totals page" to show the calculated data from
another worksheet, so that it will automatically update itself when the cells
on the corresponding worksheet is updated?

Any input is well appreciated. Thanks.

 

[Gary''s Student]

You need to do two things:

1. use links in the equations, like:
=Sheet2!E17

2. Tools > Options > Calculation > Automatic

 

[Gord Dibben]

In A1 of "totals" sheet enter ='other sheet'!A1

This links the two together and updates on other sheet is reflected in totals
sheet.

Of course this is very basic but shows the idea of Linking".


Gord Dibben MS Excel MVP

On Mon, 4 Feb 2008 09:03:00 -0800, Gunnar Boykin <Gunnar