Indirect reference to external workbooks

[GeorgeRemias]

I have several workbooks with exactly the same format but different data. I want to extract a porton of the data (always the same tab and cell address) from each workbook. Anyone know how to write a formula that does this? I tried populating a column with the workbook names and then concatenating that with text within an Indirect formula, but only get volatile results. Does not help to try an array formula, either.

 

[Ricky Morris]

The indirect function does what you want but it only works within a workbook, not with links. What you might wanna try is create sheets that to the external workbook within the workbook and use indirect to formula to these worksheets. If you need further details or example let me know.

 

[Ian Mac]

On 2002-04-11 15:54, Ricky Morris wrote:
The indirect function does what you want but it only works within a workbook, not with links. What you might wanna try is create sheets that to the external workbook within the workbook and use indirect to formula to these worksheets. If you need further details or example let me know.

I'd go with this idea, try to link directly to the book yur working on.

BUT! INDIRECT() WILL work if the other book is open, the atnerntive is to open the book via a macro from the book your working on.

Ricky, thought I'd mention, it's ALWAYS too late to learn something new if you've past the deadline you'd said you'd do it by

 

[GeorgeRemias]

[No message]