Filtering list boxes

nk0410

New Member
Joined
Dec 9, 2005
Messages
1
I have many list boxes that I use on an order form spread sheet. I'm trying to find a way to filter data from one list box to another. For example:
I have a list box for all vehicle makes, like Chevrolet and Buick and so on. I want the second list box to generate a list of models for Chevrolet. But if I select Buick, I need that models list box to only give me models by Buick. If anyone has any tips to point me in the right direction, I would be extremeley greatful.
Thanks for any help, nk0410.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Watch MrExcel Video

Forum statistics

Threads
1,118,228
Messages
5,571,008
Members
412,353
Latest member
SofiaV
Top