dependent drop down list
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
"yowzers" wrote in message
...
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.
|