Hi there,
I have built a template in excel which simply references fields in various tabs in a document, and puts the information into a single row.
The information the template needs to reference is held in excel files of a consistent format.
What I want is to have column A contain the excel file names, and the template formulas use the file name, and the consistent cell references and pull the data in from all the files.
At the moment, the template just references the original document for example:
='[DocumentA.xlsm]TabA'!B1
What I want, is to replace the '[DocumentA.xlsm] with what is written in Column A. TabA and B1 would remain the same.
Is this possible?
Bookmarks