OK, I want to have 2 drop down meus, one in A1, one in B1. A1 should be completed first. A1 will have 2 options, Yes or No. If Yes is selected, the options for B1 should be A, B, and C. If No is selected, the options in B1 should be D, E, and F.

Can this be done, and if so, how?