Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically updating data between worksheets.
You need to do two things:
1. use links in the equations, like: =Sheet2!E17 2. Tools Options Calculation Automatic -- Gary''s Student - gsnu200767 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Updating Data from Multiple Worksheets into One | Excel Worksheet Functions | |||
Automatically updating worksheets from a master worksheet | Excel Worksheet Functions | |||
Sorting Data & Updating Automatically | Excel Discussion (Misc queries) | |||
Automatically updating data from another excel spreadsheet | Excel Worksheet Functions | |||
Updating calculations automatically when i enter in new data | Excel Discussion (Misc queries) |