After a search with no success, I was hoping to receive help with linking to external workbooks while referencing a cell.
Ex: in cell A2: 110111
in cell A4 I would like to link to a workbook: ='OBSERVED-110111.xlsx'!$A$1
Problem: is there any way I can replace the 110111 in the link to reference cell A2? I am creating a template and the linked files constantly change as does the value in cell A2. These files populate many other cells and worksheets within the workbook as well.
Also, being able to perform this without having the file open would be great such as not having to use:
=INDIRECT("'OBSERVED-"&A2&".xlsx'!$A$1")
I hope this is clear, if not, please feel free to ask for clearification. Thanks in advance!
Bookmarks