Forum Discussion
External referencing using cell values
Hi I need to reference an external file for cell values within a worksheet which is straight forward, however, I need to substitute the file name the link is referencing with the text of a cell valu...
Afraid not. INDIRECT() could work, but only if other file is opened.
- Thanks Sergei. I think I will automate it with a data link to the file and fixed cell destinations. Not as smooth as I would like but it works.
Appreciate the response.
