i need to filter data that contain what the user's input, not only begins with user's input or exact

[zakizelani]

hi i was wondering if anyone can edit my code. the code here only filter if the data only if it begins with what the user input


Example:

Data:

dean winchester
sam winchester
john winchester
mary winchester


Now -
input: winchester
result: no data

want:
input: winchester
result: dean winchester
sam winchester
john winchester
mary winchester

Private Sub CommandButton1_Click()

Sheets("Database").Range("A:AG").AdvancedFilter Action:=xlFilterCopy, _
        CriteriaRange:=Sheets("Background").Range("G2:H3"), CopyToRange:=Range( _
        "A5:AG5"), Unique:=False

 

[oldbrewer]

Example:				winchester
Data:
dean winchester				dean winchester	1.00000005
sam winchester				bill winchester	1.00000006
john winchester				fred winchester	1.00000007
mary winchester				dean london	0
				dean liverpool	0
				harry winchester	1.0000001
Now -
input: winchester
result: no data
				the first 1 is
want:				=IF(ISERROR(SEARCH($E$1,E5)),0,1+ROW()*0.00000001)
input: winchester
result: dean winchester
sam winchester				now take the largest values that are greater than zer0
john winchester				and use offset match to get the names
mary winchester
			1	1.0000001	harry winchester
			2	1.00000007	fred winchester
			3	1.00000006	bill winchester
			4	1.00000005	dean winchester
			5
			6

<colgroup><col><col span="3"><col><col><col span="4"></colgroup><tbody>
</tbody>

 

[zakizelani]

hi, thanks for the reply. is it possible for to explain to me whats you trying to say? btw is it possible if you provide me a vba code for this.