How do I join a filename and a cellreference, by just filling in .

[René]

I created a table with references to several files. Each time I'm getting the
data from the same cell in each seperate file. I'd like to add a column where
I only fill in the filename. How do I combine the filled in filename with the
cell I'm referencing to.

 

[Fredrik Wahlgren]

I created a table with references to several files. Each time I'm getting the
data from the same cell in each seperate file. I'd like to add a column where
I only fill in the filename. How do I combine the filled in filename with the
cell I'm referencing to.

Hmm. Ary you saying that you use references like =[MySheet.xls]Sheet1!$C$7
and you want the reference to work in such a way that "MySheet.xls" fetched
from a cell?

If you insert the name of your file in A1, this reference will work:
=[A1]Sheet1!$C$7

/Fredrik