O'Reilly logo

Pivot Table Data Crunching by Michael Alexander, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

12. Using VBA to Create Pivot Tables

In this Chapter

Introduction to VBA 199

Tricks of the Trade 201

Versions 203

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

Report Percentages 240

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required