• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Working with PivotTables using VBA

chirayu

Well-Known Member
Hi All,

Came up with a new Tutorial for Working with PivotTables using VBA. Covers how to create pivots, add/remove/format pivotfields, add calculated fields, change data range, hide errors, filter.

Please note this is not for Beginners. You must have a basic understanding of VBA as well as the use of variables. It is also not for beginners as it is not explained in depth. There is a resources sheet at the end of the Tutorial for in depth learning.

PDF file is the Tutorial. Excel File is the sample file with the macros related to the tutorial.
 

Attachments

  • Working with Pivot Tables using VBA.pdf
    139.3 KB · Views: 20
  • SAMPLE.xlsm
    205.7 KB · Views: 13
Cool stuff.

You may find attached sample interesting. Uses code to merge 2 sheets (same structure) into one array and loads to pivot cache using ADO.
 

Attachments

  • Sample Pivot from Array.xlsb
    274.8 KB · Views: 11
Back
Top