13. Using VBA to Create Pivot Tables
In This Chapter
Enabling VBA in Your Copy of Excel
Using a File Format That Enables Macros
Understanding Object-Oriented Code
Building a Pivot Table in Excel VBA
Dealing with Limitations of Pivot Tables
Pivot Table 201: Creating a Report Showing Revenue by Category
Calculating with a Pivot Table
Version 5 of Excel introduced a powerful new macro language called Visual Basic for Applications (VBA). Every copy of Excel shipped since 1993 has had a copy of the powerful VBA language hiding behind the worksheets. VBA enables you ...
Get Excel® 2016 Pivot Table Data Crunching now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.