Over the time the amount of data we work with in Excel tends to increase heavily.
One major explanation is that we retrieve data from corporate-databases as well as from other sources for value-adding processes in Excel.
It's also quite common that we export larger amount of data from Excel to other systems.
In order to create time-saving solutions we need to leverage the use of built-in tools in VBA as well, especially two powerful tools, the Pivottable and the Autofilter.
In view of the above You will find here some examples on how to use the Autofilter-tool.
This post continues here:
The power of Autofilter in VBA - Part 2