Hi,
take a look at Debra web has excellent examples

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

"max007" wrote:

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.