validation list in a range

validation list in a range

Post by bori » Fri, 05 Nov 2004 10:31:42


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
 
 
 

validation list in a range

Post by R2FyeSBSb3 » Fri, 05 Nov 2004 10:43:01

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

 
 
 

validation list in a range

Post by bori » Fri, 05 Nov 2004 15:47:54

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?
 
 
 

validation list in a range

Post by Aladin Aky » Fri, 05 Nov 2004 16:21:01


boris Wrote:

Set Source to the name of the list as in

=COUNTRIES

where COUNTRIES refere to a range housing country names
 
 
 

validation list in a range

Post by bori » Fri, 05 Nov 2004 20:41:54

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.