ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Filter range based on results of multiple selections in a listbox (https://www.excelbanter.com/excel-programming/422212-filter-range-based-results-multiple-selections-listbox.html)

Mctabish[_4_]

Filter range based on results of multiple selections in a listbox
 
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



All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com