Link Excel Sheets


J

Jumpercables

Is it possible to link multiple excel workbooks?

Example: I have one workbook named Book1.xls that has 40 sheets in it
and anotehr workbook named Book2.xls I want to link sheets in that book
to sheets in the book1.
 
Ad

Advertisements

D

Dave Peterson

You can link cells--not worksheets.

Open both workbooks.
Select the range on the "sending" worksheet.
edit|copy
select the range on the "receiving" worksheet that should be linked.
edit|Paste special|paste link

Be aware that this link isn't bidirectional. It just retrieves data from the
sending workbook.

And if you insert/delete rows/columns in the sending workbook with the receiving
workbook closed, your formulas will still point to the original cells.

If you can pick out a unique key column in each sheet, you could use =vlookup()
or =index(match()) to retrieve values from the other worksheet.

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
 
Ad

Advertisements


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

Top