| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
have one sheet update others in workbook
I have a workbook that consists of several sheets, one of which is a chart.
My supervisor has asked me to populate a worksheet with lines of data referencing the main sheet of data as its source. This second sheet was used to create a chart. I need to impute data into the main sheet and have it update all sheets automatically. How do I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
have one sheet update others in workbook
See "Create a link to another cell, workbook, or program" in Excel help
Gord Dibben MS Excel MVP On Wed, 18 Nov 2009 14:19:01 -0800, ashadiana wrote: I have a workbook that consists of several sheets, one of which is a chart. My supervisor has asked me to populate a worksheet with lines of data referencing the main sheet of data as its source. This second sheet was used to create a chart. I need to impute data into the main sheet and have it update all sheets automatically. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update workbook | Excel Worksheet Functions | |||
| Update a autofilter sheet from another sheet | Excel Discussion (Misc queries) | |||
| Display a update date on a sheet for a shared excel workbook | Excel Worksheet Functions | |||
| Can one workbook/sheet update another workbook? | Excel Discussion (Misc queries) | |||
| Update from another sheet in same workbook | Excel Discussion (Misc queries) | |||
Linear Mode
