Use filename in cell to link data
I have a folder with 12 excel files. The first one in the range has a list of
filenames that I need to link to to retrieve specific data. How can I create
a link to external xls files using the filenames in COL F in the first file?
|