List on different worksheet

[Guest]

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

 

[Guest]

It works, are you using the list under allow as

=MyList

where MyList is the name of the list?

works fine for me


Regards,

Peo Sjoblom

 

[Gord Dibben]

Attila

Perhaps you have unchecked the option "show error alert after invalid data is
entered".

Found under the DV "error" tab.

Has nothing to do with using a named range from another sheet.


Gord Dibben Excel MVP

 

[Debra Dalgleish]

If you included any blank cells in the named range, you will be able to
type any value in the cell with data validation. If you're leaving
blanks so the list can grow, you can use a dynamic name for the range
instead. There are instructions here:

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