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

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.

"René" wrote in message
...
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