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

R

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.
 
F

Fredrik Wahlgren

René said:
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.
Click to expand...

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
 
Top