filename / cell reference for importing

[rickstaylor]

Hi Excel gurus
I have a workbook (called consolidated) that duplicates certain data from individual workbooks
Ideally, what I would like is to have a cell in the consolidated workbook where you enter the name/location of the individual file and the other cells to look that and
import relevent data

Consolidated.XLS
Cell A1 = h:\individual01.xls
Cell B1 = A1+C4

So B1 will have the contents of cell C4 from individual01.xls

Is this possible?

Hope this is clear, ideas, comments, suggestions welcome
Thanks in advance
Richard

 

[Andrew Poulsom]

You can use the INDIRECT function if the workbook is open, eg:

A1 individual01.xls
B1 =INDIRECT("["&A1&"]Sheet1!C4")

If the workbook is closed you can use the INDIRECT.EXT function in the MoreFunc Add-In:

http://download.cnet.com/Morefunc/3000-2077_4-10423159.html