Hello,

I have two columns, one called UserID, the other one called UserName. In same folder as this document I have another spreadsheet called 0001.

Is there a way for me to type in 0001 in first column, and the path for cell b, will be (example)


Cell A ... Cell B
0001 ... C:\Excel\0001.Xls

So:

Instead of the normal
=[0001.xls]Ark!A1

It would be dynamic and following what I type in the column befor as;

=[CellA.Xls]Ark!A1

- I hope that covers my question.