First of all my thanks to Gord Dibben, your suggestion worked well. Now I
encountered another problem. How would I create two (2) pull down based on
another pull down. E.g.

1st Pull down 2nd pull down 3rd pull down
1 X,Y,Z Pink, Black, Brown, Red
2 A,B,C Solid, Hallow
3 E,F,G Circle, ellipse, rectangular
4 O,P,Q Visa, MasterCard, Cash, Check

If I select 1 from the first pull down menu then the values X,Y,Z
corresponding value associated with 1) be available for the in 2nd pull down
and Pink, Black, Brown, Red
Be available for 3rd pull down and so on and so forth. Thanks.

1, 2, 3, 4 in column A, beginning A1
X, Y, Z in column B, beginning B1
....
Visa, MasterCard, Cash, Check in column H, beginning H1.
The first dropdown is in cell I1
You define a dynamic range for the second dropdown :
Name :Drop2, refers to :
=OFFSET(Sheet1!$A$1,,Sheet1!$I$1,COUNTA(OFFSET(She et1!$A:$A,,Sheet1!$I$1)))
Use this range to define the second dropdown.
Same thing for dynmic range Drop3 :
=OFFSET(Sheet1!$A$1,,Sheet1!$I$1+3,COUNTA(OFFSET(S heet1!$A:$A,,Sheet1!$I$1)))
Regards.
Daniel
"kami" a écrit dans le message de news:
...
First of all my thanks to Gord Dibben, your suggestion worked well. Now I
encountered another problem. How would I create two (2) pull down based on
another pull down. E.g.

1st Pull down 2nd pull down 3rd pull down
1 X,Y,Z Pink, Black, Brown, Red
2 A,B,C Solid, Hallow
3 E,F,G Circle, ellipse, rectangular
4 O,P,Q Visa, MasterCard, Cash, Check

If I select 1 from the first pull down menu then the values X,Y,Z
corresponding value associated with 1) be available for the in 2nd pull
down
and Pink, Black, Brown, Red
Be available for 3rd pull down and so on and so forth. Thanks.

You can use the same method to create several drill-down dropdowns

Gord

On Tue, 16 Sep 2008 12:13:03 -0700, kami
wrote:

First of all my thanks to Gord Dibben, your suggestion worked well. Now I
encountered another problem. How would I create two (2) pull down based on
another pull down. E.g.

1st Pull down 2nd pull down 3rd pull down
1 X,Y,Z Pink, Black, Brown, Red
2 A,B,C Solid, Hallow
3 E,F,G Circle, ellipse, rectangular
4 O,P,Q Visa, MasterCard, Cash, Check

If I select 1 from the first pull down menu then the values X,Y,Z
corresponding value associated with 1) be available for the in 2nd pull down
and Pink, Black, Brown, Red
Be available for 3rd pull down and so on and so forth. Thanks.