Help with creating drop down




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