Thread
:
Automatically updating data between worksheets.
View Single Post
#
3
Posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
Posts: 22,906
Automatically updating data between worksheets.
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
wrote:
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.
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben