Excel drop down lists

S

Sinead

Hi,

I am trying to create two drop down lists.
The first is a straight forward selection of 6 choices.
I would like to be able to have a list in the next column which is dependent on the choice from the first list.

For example from a choice of "A, B, C, D" in the first list, if i choose "A" I would like to have a drop down list choice of "9, 8, 7" in the second column. But if i choose "C" in the first list, then I would like to have a drop down list choice of "6, 5, 4" in the second column.

Is this possible? And if so, could you please tell me how to go about doing this?

Thanks
Sinead
 
F

Frank Kabel

Hi
see: http://www.contextures.com/xlDataVal02.html
-----Original Message-----
Hi,

I am trying to create two drop down lists.
The first is a straight forward selection of 6 choices.
I would like to be able to have a list in the next column
Click to expand...
which is dependent on the choice from the first list.
For example from a choice of "A, B, C, D" in the first
Click to expand...
list, if i choose "A" I would like to have a drop down
list choice of "9, 8, 7" in the second column. But if i
choose "C" in the first list, then I would like to have a
drop down list choice of "6, 5, 4" in the second column.
 
Top