Data Validation Lists

[Guest]

Is it possible to use Data Validation where the list of values is on one
worksheet but the dropdown list is on another worksheet? Excel won't let me
do that.

 

[Peo Sjoblom]

If you select the list, then do insert>name>define, give it a name and refer
to the name like

=MyList

in the list source box will work

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com