Searching With Text Boxes In Page

 Searching  With Text Boxes In Worksheet

The template has got 56.666 rows.That is pretty big a page.

But don't worry. Searching and filtering can be done easily with  text boxes in the page.Besides can be filtering using multiple criteria inputs from text boxes.
You can use this example for your own template.

Example code -for textbox1-  :

Private Sub TextBox1_Change()

On Error Resume Next

metin = TextBox1.Value

Set bul = Range("j4:j65536").Find(What:=metin)

Application.Goto Reference:=Range(bul.Address), Scroll:=False

Selection.AutoFilter field:=10, Criteria1:=TextBox1.Value & "*"

If metin = "" Then

Selection.AutoFilter

[j4].Activate

End If

End Sub