Searching tables and displaying results

Thanks for the response, but I would like this to be done by using VBA.

I have come across this code:

With Sheet1
            .AutoFilterMode = False
            .Range("A1:A10").AutoFilter
            .Range("A1:A10").AutoFilter Field:=2, Criteria1:=Job11
End With

But when I use it to search for "Job11" (Which is contained in A2 and A4) It filters two rows that DONT contain that information! However if it is numerical (so just 11) then it filter properly - but what if I want to filter text? Will this still keep happening?

What would be ideal is to adapt the code so that the range it is searching (A1:A1) reads as a named range and for criteria to be what is entered into a textbox (textbox1 of userform1).