Link to other workbook

  • Thread starter Thread starter dbodd
  • Start date Start date
D

dbodd

I would like to read info out of say Book4.xls into Book3.xls as per th
formulae : =[Book4.xls]Sheet1!$A$1 , =[Book4.xls]Sheet2!$A$1 etc.

But I have the sheet tab names listed in a column in Book3 . Is there
way these formulae can be put together reading the sheet name from thi
column and then dragged down into the next cells ?

Many Thanks in advance
 
=INDIRECT("'[Book4.xls]" & D1 & "'!A1")
where D1 contains the sheet name.
However, Book4 would then need to be open.
Bob Umlas
Excel MVP
 
Hi Bob ,
Many thanks. I never understood where to use the INDIRECT
function. Now this clears that up.
 
Back
Top