filter and relations between fields

[Dennis Cheung]

in cell A2, user can select only A and B, i know how to do this.
if A is selected in cell A2, i need only aa, ab, ac can be seclect in cell A3,
if B is selected in cell A2, i need only ba, bb, bc can be seclect in cell A3.

can someone tell me how can do this?

 

[Pete_UK]

Debra Dalgleish shows how you can set up dependent data validation
here:

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

Hope this helps.

Pete