How do I fiter a drop down list
 

I want to be able to select a code from a drop down. This selection must
filter another list to reduce the chance of choosing the wrong code.

How do I fiter a drop down list
 

You can create dependent data validation lists, as described he

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

Heinrich wrote:
I want to be able to select a code from a drop down. This selection must
filter another list to reduce the chance of choosing the wrong code.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

How do I fiter a drop down list
 

An exemple:

A B C D
1 Fruit Vegetables Flowers
2 Apple Potato Rose
3 Orange Carrot Tulip
4 Banana Lettuce
5 Spinach

Named ranges on Sheet Lists:
Choice1 =OFFSET($B$1,,,,COUNTA($B$1:$Z$1))
Choice2 =$B:$B

On other sheet:
First choice in B2: Data/Valid/List:
=Choice1

Second choice in C2: Data/Valid/List:
=OFFSET(Choice2,1,MATCH(B2,Choice1,0)-1,COUNTA(OFFSET(Choice2,,MATCH
(B2,Choice1,0)-1))-1)

http://cjoint.com/?bvhokpCID5
http://boisgontierjacques.free.fr/pa...es_cascade.htm

JB
http://boisgontierjacques.free.fr

On 19 jan, 03:44, Heinrich wrote:
I want to be able to select a code from a drop down. This selection must
filter another list to reduce the chance of choosing the wrong code.