| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
synchronize worksheets with master worksheet
If the data is perfectly aligned then you can do stuff on Sheet d like
=SUM(Sheet a!:Sheet b!A1) " wrote: I have four separate worksheets named a, b, c, d which the data for each one is combined in a fifth worksheet called master all on the same workbook. I am trying to make it so when I update data from any of the a-d worksheets the changes also update on the master worksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically updating worksheets from a master worksheet | Excel Worksheet Functions | |||
| Master Worksheet populated by other Worksheets? | Excel Worksheet Functions | |||
| Master Worksheet reflecting sub-worksheets | New Users to Excel | |||
| Create a master worksheet based on 2 different worksheets | Excel Worksheet Functions | |||
| how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions | |||
Hybrid Mode
