Excel® 2016 Pivot Table Data Crunching

13. Using VBA to Create Pivot Tables

In This Chapter

Enabling VBA in Your Copy of Excel

Using a File Format That Enables Macros

Visual Basic Editor

Visual Basic Tools

The Macro Recorder

Understanding Object-Oriented Code

Learning Tricks of the Trade

Understanding Versions

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

Using Advanced Pivot Table Techniques

Using the Data Model in Excel 2016

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