Pivot Table Data Crunching: Microsoft® Excel® 2010

12. Using VBA to Create Pivot Tables

In This Chapter

Introducing VBA 245

Learning Tricks of the Trade 249

Understanding Versions 251

Building a Pivot Table in Excel VBA 254

Dealing with Limitations of Pivot Tables 258

Pivot Table 201: Creating a Report Showing Revenue by Category 264

Calculating with a Pivot Table 276

Using Advanced Pivot Table Techniques 288

Creating Reports for Each Region or Model 292

Formatting a Pivot Table 305

Introducing VBA

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 to perform steps that you normally perform in Excel quickly and ...