If you name the list on the other sheet, you can refer to it by name in
the data validation dialog box. There are instructions he

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

smskater wrote:
Is there a way of using a list from another worksheet without having
to bring the list into the current worksheet?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html