Autofilter for multiple column

Hi, I'm trying to do a filter on change in a textbox such that if it contains the value in any of 2 column it will remain in the table.
For this example, the value user entered is a, so I would like to retain the entry as long as it has a appearing in either or both column.
My codes are as follows but it doesn't work. It will only return results that contain the value in column A:

Please Login or Register  to view this content.

Value 1	Value 2	Result
a	b	Retain
b	a	Retain
a	a	Retain
b	b	Filter Out

Is there no solution available?

It would be easier if the data was in a range, rather than a table, as you could use advanced filter to achieve what you seem to be after. Try the code below on a copy of your workbook. It assumes the criteria is in cell I4 (as per your original post). 2 codes provided. The first deals with a table, the second with a range.

Please Login or Register  to view this content.