On Jun 5, 5:59*pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
John,

You can use a macro to create formulas that link to the file based on the
values of the headers cells - or *you can simply copy the formula and edit
it to include the new worksheet name.

Bernie

"John" wrote in message

...
On Jun 5, 12:47 pm, JE McGimpsey wrote:

To use INDIRECT() the target workbook needs to be open.

In article
,

John wrote:
It gives me a #REF error when I try to use it. Even tried just using
indirect to return set cell and was unable to do so.- Hide quoted text -

- Show quoted text -

Ah, that's the problem then. *Anyway to do it without having the
workbook open?

OK. Was hoping to avoid having to do either of those two but it
appears it's down to that. Thanks for the help.