If you name the range that contains the validation list, you can refer
to it on another sheet. There are instructions he

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

Ronaldo wrote:

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