Data validation dropdown list

[Bernie Simmonds]

The Data validation dropdown list appears to need the list of validation
data same work sheet. I would like to have my validation data on a
separate sheet.
Can this be done?

Bernie Simmonds

 

[Dave Peterson]

If you name the range, you can use that.

See Debra Dalgleish's site for some nice pictures:
http://www.contextures.com/xlDataVal01.html#Name

 

[Bernie Simmonds]

Thanks Dave, Bernie

If you name the range, you can use that.

See Debra Dalgleish's site for some nice pictures:
http://www.contextures.com/xlDataVal01.html#Name