Help with Excel 2000

M

Mark Cillis

I have a data list created in Excel 2000 that I want to
have linked to multiple worksheets in the same workbook. I
will have 5 additional pages of reports that I want to link
to the main worksheet in the workbook. The main worksheet
has over 2000 entries and I can't figure out how to get the
other sheets to link to the main one, so that any changes
made in the main worksheet are shown on the other
worksheets. Can anyone help me with this project? I hope I
explained it in a way you can follow what I am trying to do.

Thanks,
Mark
 
D

DL

Treat extra sheets the same as if you are working on mainsheet
ie select cell on mainsheet, copy or whatever, then select other sheet
target cell
 

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

Visio to Excel 0
Embed the same Excel multiple times 0
Create a dynamic master file 1
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
How to update data from linked worksheet back to a master worksheet? 0
How to update a value from a linked worksheet back to the master worksheet? 0
Linking Workbooks - Reopen Error 0

Top