Chapter 6. Table Views
Users often apply different filters to the loaded data, hide and unhide columns, sort in various ways, etc.
The SaveToDB add-in can help to save such user views and even share them with colleagues.
Let's remove all WHERE filters and click the Save Table View button in the Table Views group:
Type All Payments and click Save.
We see the name of the current view, All Payments, in the Table View field.
Type >0 in cell E2.
The add-in applies the filter to the Sum column.
This is a reason why it is better to insert tables at cell B3.
Users can use row 2 (as a row over the table) as auto-filters. Also, they can place formulas in row 1.
Let's continue and save the view as Incomes (click the Save Table View button again):
Type <0 in cell E2.
The add-in applies the new filter to the Sum column.
Save the view as Expenses.
Remove the filter in cell E2 and apply the Incomes view in the Table View list:
As we can expect, the add-in applies the saved filter to the Sum column.
You can use the auto-filter row and table views for any Excel table.
Moreover, you can save views for pivot tables also.
I am sure you will like these features.