Working with Auto-filters
Today we discuss a useful feature for working with auto-filters.
We have connected to a database in the previous step.
You may use your file or download and open the following workbook
We have inserted the table into cell B3, and it looks like this:
Now we may use row 2 (the first one over the table) to manage auto-filters.
Try to type >100000 in cell E2. The add-in will apply the auto-filter:
Clear the value, and the add-in will clear the auto-filter.
You may use the asterisk to filter text values.
For example, try to type *inc* in cell G2:
I like this feature. Hope you will like it too. You may use it with any Excel table.
You may enable or disable it using the Advanced tab in the SaveToDB options.
CEO | Gartle Technology Corporation