Help with creating drop down

M

max007

Hi,,

can anyone help me on how i can create a drop down combination(i'm not sure
what it is called)?

x y z
X1 y1 z1
x2 y2 z2
x3 y3 z3

What im trying to do is if cell A1 has a drop down list(with X,Y,Z
selection), i would like cell B1 to return another drop down list that
contains a list corresponding to what was selected in cell A1.. so if cell A1
is Y, then cell B2 will show another list with Y1,Y2 and Y3 selection...

Im using MS Office 2007.

Please advise and thank you very much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Link drop-down list? 1
Drop down list control value in vba 2
User Defined Array Function 4
Simple example of a range argument to a UDF? 6
Excel VBA 2007 - Combo Box 6
How do I set the source data to make this graph? 0
Sort coordenates independently 0
To Link drop-down list 1

Top