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
Bookmarks