List on different worksheet

B

bevpike

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
 
P

Peo Sjoblom

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
 
G

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
 
D

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
 
Top