Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid?
On Monday, November 11, 2013 12:30:27 PM UTC-5, wrote:
I have to extract cell values into a summary spreadsheet from multiple closed workbooks saved in Google Drive.
For the benefit of others interested in this very useful functionality, an example below should provide a quick start:
=INDIRECT.EXT("'"&A1&"["&A2&"]"&A3&"'!B$1")
where, for example,
A1 contains the directory/folder path, such as C:\User\My Documents\Me\Dropbox\ (keep the final backslash!)
A2 contains the workbook name, such as Summary.xls
A3 contains the worksheet name, such as Data, and
B$1 is the cell address with the data of interest.
Pay attention to the order of single and double quotes!
|