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 pretty 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.

#Searchtable