conditional list

S

sailingHLA

I am trying to create a dependent list for a drop down menu. My table is set
up as follows:

A B
Mammal Cat
Mammal Dog
Insect Cockroach
Plant Tree
Plant Flower
Insect Cricket

I need to create a drop down that would only have the options in it if the
number in column A is either Mammal or Plant. So basically, I need to create
a drop down in a certain cell that would only have Cat, Dog, Tree and Flower
in it. Any help would be appreciated.
 

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

linking 2 drop down boxes, not the cascading way 4
How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Set as Default Template not working 0
Conditional validation with only two columns 7
Newbie Help 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Counting Values in a list 2

Top