The 3rd point consumes huge time because record macro inputs code for each field selection.
Instead of selecting the Fields manually loop through the PT Field List so that the selection process will occur in high speed.
Refer the below link to get some understanding about how to loop through the PT fields
http://jamiche.blogspot.in/2011/04/v...-in-pivot.html
Bookmarks