Partial Match Search Results on User Form

Hi,

I have a user form that searches my data by different criteria depending what you are looking for which works perfectly except I would like the "Location" to also return partial matches.

My code filters the table by: CriteriaRange:=Range("FilterCriteria"). FilterCriteria is a dynamic list that doesn't always have the same values however I would like it to partial match the values in "FilterCriteria" specifically just the the Location column (On the workings sheet), Is this possible?

The reason Id like to do this is because if you look at my fake data in the location column you'll see "Cumbria Bristol". It should work so that if I search my data by the location "Bristol" they also appear but currently they don't. Eventually this would be expanded so there could be 50 locations listed in a single cell (Which my Input Data form has been adapted to add all the locations)

Thank You

Add asterisk at both ends for the criteria that you want. eg

Please Login or Register  to view this content.

Worked perfectly, Thank You!