I am wondering if it is possible to use a helper cell to update the file path/name for some linked data that I am working with. Right now I have several cells which are formatted as follows:
=‘File Path[File Name]Sheet Name’!Cell Ref
and I would like to know if there is a way that I can modify this to reference a cell that contains the file path instead. The reason for this is that I am looking to use this file for multiple sets of data which have the same sheet name and cell reference that I would be working with but the file path and file names would obviously change. I was trying to do something like the following:
=‘&C1&”[“&C2&”]Sheet Name’!Cell Reference”
but every time I go to enter that, excel immediately brings up the file explorer for me to select the file I want to link to.