Conditional lists for a Combo Box

[Guest]

I want to create a Combo Box that will display 1 of 6 lists once a condition
is met, kind of like an IF statement. I have two Combo Boxes. The first
displays the same list all the time - no problem. I want the second Combo Box
to display 1 of 6 lists depending on what was selected in the first Combo
Box. Is this possible? If so, can someone explain how to do it.

Thanks

 

[Guest]

Mike,

Take a look here at creating dependent lists using data validation:

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

HTH