dependent drop down list

  • Thread starter Thread starter yowzers
  • Start date Start date
Y

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.
 
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
 
Back
Top