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.