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


wrote:
Hello,

I have try out couple of times to setup a validation in
excel spreadsheet from different spreadsheets and I can't
allow me to proceed.

I can setup the validation in same spreadsheet but not in
different spreadsheet.

Appreciate your advise.


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