| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Automatically update data across worksheets
I have an Excel worksheet containing 4 worksheets. The main data is in Sheet 1. I need to update certain cells in Sheet 1 regularly and those cells are repeated in sheets 2,3,and 4. My question is can I update the whole lot automatically to save having to open each worksheet every time? -- Lancashire Lass |
|
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
|
Automatically update data across worksheets
One way:
In the repeated cells, use =Sheet1!A1 In article , Lancashire Lass wrote: I have an Excel worksheet containing 4 worksheets. The main data is in Sheet 1. I need to update certain cells in Sheet 1 regularly and those cells are repeated in sheets 2,3,and 4. My question is can I update the whole lot automatically to save having to open each worksheet every time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| how do i get the data in a chart to automatically update? | Charts and Charting in Excel | |||
| Update data automatically among worksheets | Excel Discussion (Misc queries) | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| how do I update automatically other worksheets in a file | Excel Discussion (Misc queries) | |||
![Lancashire Lass[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
