Refer to seperate workbook for validation list for drop downs?
 

Id like to keep my validation data for drop downs in a seperate workbook so
that many users/worksheets can reference it. However- data validation doesnt
seem to let me reference named ranges in a seperate workbook- any advise out
there?
--
Dee

Visit Debra Dalgleish's site:
http://www.contextures.com/xlDataVal05.html

But take note that the other workbook has to be open.

Dee wrote:

Id like to keep my validation data for drop downs in a seperate workbook so
that many users/worksheets can reference it. However- data validation doesnt
seem to let me reference named ranges in a seperate workbook- any advise out
there?
--
Dee

--

Dave Peterson

http://www.contextures.com/xlDataVal05.html


--

Regards,

Peo Sjoblom


"Dee" wrote in message
...
Id like to keep my validation data for drop downs in a seperate workbook
so
that many users/worksheets can reference it. However- data validation
doesnt
seem to let me reference named ranges in a seperate workbook- any advise
out
there?
--
Dee