dependent drop down list

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.
 
O

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top