12. Using VBA to Create Pivot Tables
In this Chapter
Build a Pivot Table in Excel VBA 203
Revenue by Model for a Product Line Manager 210
Handle Additional Annoyances 214
Issues with Two or More Data Fields 220
Summarize Date Fields with Grouping 226
Advanced Pivot Table Techniques 230
Control the Sort Order Manually 239
Sum, Average, Count, Min, Max, and More 239
Introduction to VBA
Version 5 of Excel introduced a powerful new macro language called Visual Basic for Application (VBA). Every copy of Excel shipped since 1993 has had a copy of the powerful VBA language hiding behind the worksheets.
Enable VBA in Your Copy of Excel
If you are using Excel 2000 or newer, ...
Get Pivot Table Data Crunching now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
