If you use defined/named ranges, you can.
Apply it in the DV with Allow: List, Source: =MyRange
where MyRange is a defined range
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DP7" wrote:
Is there any way for me to create a drop down box from a list of data in a
different work from the one the drop down box will be in???