use cell contents to reference other workbooks

J

Jack

I need to be able to enter a workmanbook name in a cell,
then use a reference to that cell in formulas (instead of
the workbook name) to reference data in the other
workbook. I cannot figure out the syntax. Is this
possible?
 
N

Norman Harker

Hi Jack!

Try as an Example:

=INDIRECT("'["&A1&"]Sheet1'!A14")

Returns A14 in Sheet1 of the workbook named in A1

With INDIRECT the workbook needs to be open.

But if the workbook is closed then you will have to use a function
developed last year by Harlan Grove:

See:
http://www.google.com/[email protected]

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top