Conditional Formulas & Drop Down Boxes

S

Skibee

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
 
C

CurlyDave

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 offera
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 varietiesof
Savoy and likewise for Dutch White Cabbage.

Can this be done and if so how?

Help much appreciated.
Thanks
Click to expand...

Check out Dependent drop down lists

http://www.contextures.com/xlDataVal13.html
 

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

Similar Threads

produce list automatically from choice of drop down list 1
Selective Validation 4
Drop Down Box Selection 3
Drop Down choice needs to lead to another drop down menu 1
Conditional Drop Down Boxes 1
Totalling data used in drop down boxes? 3
Drop Down - Repost 4
Data Validation & Drop Down Boxes 2

Top