Filter range based on results of multiple selections in a listbox

M

Mctabish

I want to be able to filter a set of data this is in A4:S543

I want to display a list of items from column F (F4:F543) in a listbox (or
similar) where multipule items could be selected by the user, and then
filter the data based on column F

Below is a small excert of data from F and the column in front and behind

How could this be down?

Sample data:
E F G
A/C Center LocatorId
559 CHOWCHILLA SKTNCA01XEY
559 CHOWCHILLA SKTNCA01XEY
559 CLOVIS N/A
559 CLOVIS WEST
831 FELTON WEST
831 SANTA CRUZ WEST
559 CLOVIS
831 FELTON N/A
831 FELTON N/A
831 SANTA CRUZ N/A
510 HRCUL-RODE 9105
510 HRCUL-RODE 9105
510 OKLD ALMD 9103
510 OKLD ALMD 9103



Thanks,
Bruce
 

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

UserForm Listbox Selected Item Manipulation 5
Filtering using multiple selected items in a list box 0
Set data filter based on user selections 3
Extended DataValidation Dropdown Listbox - Object Creation/Inherit 1
Listbox vs Combobox 0
How to set a button to filter a table using specific from and tocells data 4
Pass selection in multi-field listbox to query-based subform (repo 7
Selecting Filtered Items from Named range 2

Top