dependent drop down list
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. |
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. |
All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com