Using text value in cell as input for another

Me again ... while I am here ...

My spread sheet contains a first column with unique values and the remainded
of the colums are referenced in another spreadsheet of data ...

Is there a way to use the text in cells A1 ... A200 as the input parameters
to reference another named workbook of the same name ..

I know I will have to enter the path of these other sheets, but their name
is still the same

MAny thanks again

Alan

It kind of sounds like you'd want to use =indirect(). But if the workbook is
closed, then =indirect() won't work.

Harlan Grove wrote a UDF that allows you to retrieve values from a closed
workbook when you build that string that points at the
drive/folder/filename/sheetname/range address.

http://www.google.com/groups?selm=sH...wsranger. com

Alan wrote:

Me again ... while I am here ...

My spread sheet contains a first column with unique values and the remainded
of the colums are referenced in another spreadsheet of data ...

Is there a way to use the text in cells A1 ... A200 as the input parameters
to reference another named workbook of the same name ..

I know I will have to enter the path of these other sheets, but their name
is still the same

MAny thanks again

Alan

--

Dave Peterson