dependent drop down list

[yowzers]

I know that you can create a list (i.e. Produce - Fruits, Vegetables, etc.)
and then a dependent list (i.e. Fruits -Apples, Oranges, etc.). But you have
to use two columns. For example, column A is data validated for the Produce
list and you choose Fruit. Then column B is data validated for the dependent
lists where you can choose Apple.

Is there anyway to do this without the use of column B and have everything
on column A? So basically, in column A, you would put your cursor over Fruit
in the drop down list and then a second drop down list would appear to the
right side of the drop down list and you can choose Apple and this would be
the selection in column A.

 

[Otto Moehrbach]

Not the way you describe. You can use VBA programming so that after you
select Fruit in the column A cell drop-down, the cell would clear and
another drop-down would be available in the same cell. You click that
drop-down arrow and it would display some fruits from which you can select
Apple. Does this sound like what you want? HTH Otto