Filter columns by typing text in a search box?

Hi Guys, basically I want to be able to filter columns in a table by searching with text, rather than the cumbersome drop down filter built in to Excel.

(See attached)

The idea is to have a search box above each column.

For example if I were to type "S" into the A column search box and press enter, this would then filter out all rows which do not contain "S"

Then I can move to the next box and filter further.


I am looking for the exact same functionality as is already available through the filter built into excel with drop down menus, but I need to be able to type for quick access.

Any help or advice you can all give me would be much appreciated!

Mickey