Chapter 12. Using VBA to Create Pivot Tables

IN THIS CHAPTER

Introduction to VBA

Tricks of the Trade

Versions

Build a Pivot Table in Excel VBA

Revenue by Model for a Product Line Manager

Handle Additional Annoyances

Issues with Two or More Data Fields

Summarize Date Fields with Grouping

Advanced Pivot Table Techniques

Control the Sort Order Manually

Sum, Average, Count, Min, Max, and More

Report Percentages