Attempting to autofilter a dataset based on keywords which are part of a text string

Hi all,

I have the code below which auto filters a data-set in column 10 based upon a list of values on separate worksheet. The code works perfectly when I'm filtering based on the complete text string, i.e 'computer equipment'.

I'm now trying to modify the code so that I can auto-filter based on a single piece of text within the string, i.e. 'computer' or 'equipment', and not necessarily 'computer equipment'.

I've searched for an answer but can't find anything helpful, any help would be appreciated.

Thanks

David

Please Login or Register  to view this content.

Untested. Try on a copy first.

Please Login or Register  to view this content.

Hi John and venkat1926,

Thank you both for the code, I've tried your John but it doesn't seem to work. The original code I posted autofiltered with a exact match of the text string but unfortunately your neither picks up an exact match or a work within the string.

I've attached a sample of the workbook with your code and I'm wondering if you wouldn't mind having a look?

Thanks again.

David