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?

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?