View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gunnar Boykin Gunnar Boykin is offline
external usenet poster
 
Posts: 1
Default Automatically updating data between worksheets.

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.