have one sheet update others in workbook

A

ashadiana

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?
 
G

Gord Dibben

See "Create a link to another cell, workbook, or program" in Excel help


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto update worksheets 2
Copying Data from Multiple Sheets to One sheet 1
Excel, assign cells in multiple worksheets from one sheet 1
Excel Workbook with Multiple worksheets 2
Individual sheet protection in shared workbook 1
All sheets in workbook have same rows to repeat at top 1
Update multiple sheets 1
search and copy text from one sheet to others 4

Top