Changing Excel AutoFilters Using Cells

The SaveToDB add-in allows using rows above Excel tables to change or clear Excel AutoFilters.

You can turn on or off this feature using the Options dialog box.

To change a filter, enter a value in the cell above the table column. To turn off the filter, clear the value.

You can use the following substitution characters: ?, *, >, <, <>.

For example, the "<>*AA*" value filters all the rows except for the rows which contain "AA".

The ">100000" value filters all the rows with values greater than 100000.

The "*Inc*" value filters all the rows with values that contain "Inc".

Here is a sample: