How to create a dropdown list that contains filtered values

[Frank Kabel]

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

for dependent listboxes

-----Original Message-----
Hi,

Would it be possible to do the following?
I would like to define a list that shows values from a

column, but only shows those values that have matching
attributes in their rows. I'll try to give an example.

In Sheet 1 I have Column A that I will fill with Car

Brands. In Column B I will put the colour for each car.

In Sheet 2: I will select a colour in column A Row 1, and

now in B1 I want a dropdown list that only shows the
brands from Sheet 1 Column A that match with the colour a
selected in A1.

Sheet 1:
A B
1 Ferrari Red
2 Fiat Red
3 Porche Black
5 Renault White

Sheet 2:
A B
1 Red (Dropdownlist that will only show Red Cars [Ferrari & Fiat])


Is this possible?

Thanx for any input on this!!

Michiel

.