Using Named Ranges to Lookup Data in External Workbook

[Andibevan]

Hi All,

Does anyone know of or have any guidance on how to setup named ranges so
that you can reference them (i.e. lookup data using them) from an external
sheet?

I have worked out how to do it but I am not sure how to ensure that it will
work correctly when distributed to the user?

Thanks in advance

Andi

[Tom Ogilvy]

A named range is a named range. If it exists, it can be used like any other
range. If it is from an external source, then it would be used like any
range reference from an external source.

--
Regards,
Tom Ogilvy


"Andibevan" <[email protected]> wrote in message
news:[email protected]...
> Hi All,
>
> Does anyone know of or have any guidance on how to setup named ranges so
> that you can reference them (i.e. lookup data using them) from an external
> sheet?
>
> I have worked out how to do it but I am not sure how to ensure that it
will
> work correctly when distributed to the user?
>
> Thanks in advance
>
> Andi
>
>