Microsoft Excel 2019 Pivot Table Data Crunching

Chapter 13Using VBA to create pivot tables

In this chapter, you will:

• Enable VBA in your copy of Excel

• Use a file format that enables macros

• Use the Visual Basic Editor

• Discover Visual Basic Tools

• Try to use the macro recorder

• Understand object-oriented code

• Learn tricks of the trade

• Understand versions

• Build a pivot table in Excel VBA

• Deal with limitations of pivot tables

• Create a report showing revenue by category

• Calculate with a pivot table

• Use advanced pivot table techniques

• Use the Data Model in Excel 2019

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