Hi

I'd like to have a drop-down list in one cell and based on
the selection in this cell, there needs to be another list
of drop downs in an adjacent cell. How do i do this?

Eg - first cell would have drop down - A, B , C

If A is selected, the drop-down needed in anotehr cell is
AA, AB, AC, AD. And if B is selected, the second cell
should drop down BA, BB, BC, BD.

Pls help.

thanks

I'd like to have a drop-down list in one cell and based on
the selection in this cell, there needs to be another list
of drop downs in an adjacent cell. How do i do this?

See here http://www.contextures.com/xlDataVal02.html for chapter & verse.

Rgds,
Andy