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?

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" wrote in message
...
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?

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