Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formulas & Drop Down Boxes
Is it possible to do the following:
Column A is entitled "Crops" and offers a drop down box from which the user will select one of three crops (ie. Broccoli, Savoy, Dutch White Cabbage). Column B is entitled "Varieities". If Broccoli has been selected in column A, I would like column B to offer a drop down box listing all the varieties of Broccoli; but if Savoy has been selected in column A, then I a drop down box to display all the varieties of Savoy and likewise for Dutch White Cabbage. Can this be done and if so how? Help much appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down boxes/tick boxes | Excel Worksheet Functions | |||
Help With Drop Down Boxes | Excel Discussion (Misc queries) | |||
Conditional Drop Down Boxes | Excel Discussion (Misc queries) | |||
Can you add formulas into drop boxes?? | Excel Worksheet Functions | |||
Conditional Formulas that return different drop down lists | Excel Discussion (Misc queries) |