I wish to create a drop down list and put the list on a different worksheet
than where the drop down will be used. I also want to validate. I was able
to put the actual list on a separate worksheet using a named range but it
when a value not contained in the list was typed in the cell it did not apply
the validation (normally a stop message would come up if you indicate to do
so).

How do I ensure there is validation when a list is located on a separate
worksheet?

Attila