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