I am having a problem with validation.
i.e. in cell B2 there is a validation box that lists Yes, No.

When Yes is entered in B2 I need to have cell B3 read "A"
When No is entered in B2 I need to have in cell B3 have a
list B, C, D, E, F displayed to be chosen by the user.

I can get this to work, however, I need to make sure that
if "Yes" is selected the letters (B, C, D, E, F) in cell B3
are "automatically" changed to "A" and inversely if "No" is
chosen the list of B, C, D, E, F is displayed for the user
to pick from.

Thanks,
Marty