Indirect Function

[Sam]

I have a spreadsheet with multiple sheets and need to
extract data from a particular from each sheet. To
extract this data, I use the following formula:
=Indirect("'"&A5&"'!B5") where A5 is the name of the sheet
and B5 is the cell I wish to extract from each Sheet.

Here is my question: If I decide to enter the Indirect
Formula in a different spreadsheet than the one which has
the information, how would I write the formula above?
Let's say the Spreadsheet I want the Indirect to point to
is called "March Financials".

Sam

 

[Bob Phillips]

Hi Sam,

You can either include the workbook name in the cell, or in the formula, but
A5 or the should be in the form '[excelfile.xls]Sheet1!', or the formula
should be

=Indirect("'[excelfile.xls]"&A5&"'!B5")



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)