Searchable Table
Here it is! Finally a table of data that can be searched.
The VBA component to this is actually minimal.
2 helper columns, a couple of small macros et voila! We have a searchable table!
Ever since stumbling on a similar version to this over at chandoo.org prety much all of the Spreadsheets that I create for work will include a searchable table.
Download template: SEARCHABLE TABLE TEMPLATE.xlsm
To break it down:
-
1 table of data
-
1 forms control text box linked to a cell (example spreadsheet linked to $G$1)
-
2 helper columns
-
Macro 1: Worksheet change event for the text box which updates the filters in the helper column when a new letter is entered. Note that it filters text and numbers, dates will be filtered as a number e.g. 01/01/1900 is "1"
-
Macro2: Clears the text box and also unfilters all columns.
