Automatically updating data between worksheets.

  • Thread starter Thread starter Gunnar Boykin
  • Start date Start date
G

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.
 
You need to do two things:

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

2. Tools > Options > Calculation > Automatic
 
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
 
Back
Top