validation list in a range

B

boris

I have a defined range (separate sheet from the
validation, but can be moved), and would like for the
range to serve as my list of values in a "list"
validation. Suggestions?

Boris
 
G

Gary Rowe

select data/validation. In the drop down box title "Allow" select list and
for the source select the range of values.
 
B

boris

Right, but I specifically want to use the name of a range,
so that I can place it anywhere and not have to worry
about validation being updated. Is there a way to do that?
 
A

Aladin Akyurek

boris said:
Right, but I specifically want to use the name of a range,
so that I can place it anywhere and not have to worry
about validation being updated. Is there a way to do that?
Click to expand...

Set Source to the name of the list as in

=COUNTRIES

where COUNTRIES refere to a range housing country names
 
B

boris

Thanks...thought I had tried that, and that was why I was
writing, but maybe the first time I did not type it
correctly. Works great now.

Boris.
 
Top