VBA and Macros: Microsoft® Excel® 2010

13. Using VBA to Create Pivot Tables

IN THIS CHAPTER

Introducing Pivot Tables

Understanding Versions

Creating a Vanilla Pivot Table in the Excel Interface

Building a Pivot Table in Excel VBA

Using Advanced Pivot Table Features

Filtering a Data Set

Using Other Pivot Table Features

Introducing Pivot Tables

Pivot tables are the most powerful tools that Excel has to offer. The concept was first put into practice by Lotus with its Improv product.

I love pivot tables because they are a fast way to summarize massive amounts of data. The name pivot table comes from the ability you have to drag fields in the drop zones and have them recalculate. You can use the basic vanilla pivot table to produce a concise summary in seconds. However, pivot tables ...