Dynamic Ranges

[JackR]

I have a drop down list in one workbook and want to have it look up a dynamic
named range in another workbook, can this be done or does the list have to be
in the same workbook?

[Bob Phillips]

It can be another worksheet if you use a named range, but not another
workbook.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JackR" <[email protected]> wrote in message
news:[email protected]...
> I have a drop down list in one workbook and want to have it look up a
dynamic
> named range in another workbook, can this be done or does the list have to
be
> in the same workbook?
>

[Dave Peterson]

Take a look at Debra Dalgleish's notes:
http://contextures.com/xlDataVal05.html

JackR wrote:
>
> I have a drop down list in one workbook and want to have it look up a dynamic
> named range in another workbook, can this be done or does the list have to be
> in the same workbook?

--

Dave Peterson