Pivot tables
Yan
Indeed pivot table is an excellent tool to sort and manipulate data. If you want to automate certain task in pivot table, you could write a macro for that. The best way would be to record a macro for the action you want to automate and then customize that macro accordingly.
In case you need any help with this, you can message me.
Sandeep