dynamic external cell reference
Any help is appreciated... really stuck on this.
I am trying to reference an external cell where the file name
changes/corresponds to a particular local cell value.
For example:
Column B= Username.
Cell B2 = [JOE].
I want to get the data from cell N6 in the excel spreadsheet named
c:\data[joe].xls
I want to use a formula that uses the username in the cell reference... In
the above example, I'm trying something like
=data'B2'.xls!N6
to try and get
=dataJOE.xls!N6.
I'm also trying INDIRECT() function...
in C2 ="data"&B2&".xls!N6" which returns "datajoe.xls!N6"
then in D2 I use =Indirect(C2)
but can't get D2 to actually return the value for =dataJOE.xls!N6
Thanks
B
_________________
An idea is salvation by imagination.
- Frank Lloyd Wright
|