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: