Searchable Table!
![](https://static.wixstatic.com/media/db839d_fbc61e5f6c024124a2fdd1950e58cc4b.png/v1/fill/w_400,h_168,al_c,q_85,enc_avif,quality_auto/db839d_fbc61e5f6c024124a2fdd1950e58cc4b.png)
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
![](https://static.wixstatic.com/media/db839d_c9ef3a29fe1b4ae0a24dd2d3e1923eaa.gif/v1/fill/w_980,h_380,al_c,usm_0.66_1.00_0.01,pstr/db839d_c9ef3a29fe1b4ae0a24dd2d3e1923eaa.gif)
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.
![](https://static.wixstatic.com/media/db839d_4163caac0384421f874a9d43a340fa3a.png/v1/fill/w_980,h_301,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/db839d_4163caac0384421f874a9d43a340fa3a.png)