Drop Down Selection Based on Value in A1

[BIGTONE559]

I need help with limiting the choices in b1 by value selected in a1.


I have values in A1 and B1 and they are both drop down boxes that refer to
lists on sheet 2.
a1=Sheet(2)A1:A3
b1=sheet(2)b1:b20

A1 Refers to 3 values. Fruits Veggies Candy

B1 refers to a list
apples
oranges
carrots
celery
pop rocks
reeses


i would like when a1 is selected you can only choose fruits in b1. How would this be done without VBA?

 

[HalfAce]

Try doing a search here on "Dependent Dropdowns"

There should be plenty to wade through.

Hope it helps.
(and, naturally, post back if you have questions or need a hand figuring it out.)

 

[BIGTONE559]

Half Ace. . . Thanks for the direction. I don't mind looking just unfamiliar with the wording. . .

I've already found tons of stuff.

 

[HalfAce]

By all means, post back if you need a hand figuring any of it out.