Spreadsheet: 193894d1352986060-instant-search-in-excel-2007-fastfilter
Sheet: Instructions

 | FastFilter
 | With FastFilter, you can type criteria in the row above an AutoFilter, instead of selecting from the
 | dropdown lists. The cells with criteria change colour, so you can easily see which columns have a filter applied,
 | and see what the criteria are. You can filter one or more of the columns.
 | The FastFilter works by using event code, which runs when a change is made on the worksheet.
 | To see the code, right-click on the Products sheet tab, and click View Code.
 | Using FastFilter
 | To apply a simple filter:
 | In the cell above a column, type an exact match for the value you want to filter.
 | For example, on the Products sheet, type a number in the blank cell above the SupplierID column.
 | The table will be filtered, to show only the orders for that supplier
 | The focus stays on the cell where the entry has been made, so it's easy to delete or change the criteria.
 | To remove a filter:
 | Press DELETE in the target cell to remove criteria and return to full list view.
 | To use wildcards in a filter:
 | To make the filter more flexible, you can use the * and ? wildcard characters.
 | The * wildcard represents any number of characters; for example, box* will filter the list for box or boxes
 | The ? wildcard represents a single character; for example, bo? will filter the list for box or boy, but not boxes
 | You can use the wildcard characters in any position in the criteria, such as *box, box*, [NAME], or *bo*
 | To use multiple criteria in one filter:
 | To use the OR function to include 2 criteria, use the double caret "^^"
 | For example,    f* ^^ m*  will find anything beginning with F OR beginning with M
 | To use the AND function, use a single caret in your expression
 | For example,   >25 ^ <50  will find anything with values over 25 and less than 50
 | Notes on FastFilter
 | You can make as many selections as there are columns in your table that have autofilter applied, and you can easily see what
 | criteria you have used.
 | The code works with all versions of Excel from 97 through to 2007
 | It also deals with the List object in Excel 2003 if Data>List has been used to provide the selection dropdowns, and with the
 | Table object in Excel 2007 if Insert>Table has been used.
 | All data has been taken from the Microsoft © Northwinds database
 | Set Up the Worksheet:
 | Enter a table of data, such as the table on the Products sheet, with data in rows and column
 | The first row of the table should contain a heading for each column of data.
 | Insert a blank row above the heading row.
 | Create a List or AutoFilter:
 | Optional: In Excel 2003, you can convert the table to a List --
 | Select a cell in the table, and from the Data menu, choose List>Create List
 | Click OK to create the List
 | AutoFilter dropdowns are automatically created in the List's heading row.
 | If you did not create a List, turn on the AutoFilter feature --
 | Select a cell in the table, and from the Data menu, choose Filter>AutoFilter
 | Add the Event Code:
 | To copy the event code, right-click on the Products sheet code, and click View Code.
 | Select all the code, and copy it
 | Right-click on the sheet tab for your table's worksheet, and click View Code.
 | Paste the code where the cursor is flashing.