PivotTable as AutoFilter

One of the recurring questions in the blog refers to as applying AutoFilters in the databases. 

We have to have a summary of information, most of the time the filters that are required include the application in various fields of database which makes tedious being switching from one filter to another, here is where you can perfectly apply the process to filter data by dynamic and with two clicks have data that meet certain conditions table clearly is very important to see in that area of ​​the PivotTable done that click.

 if in the totals for a column or row or at the point of intersection of two of them, with the advantage that a data table is created in a new sheet containing the information requested without changing anything in the pivot table that we created.

If this information helpful to your liking share it by clicking the button from different social networks at the end of the publication.

If you want to keep abreast of our follow us on various social networking publications, we are just a click away ...