Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 13. Using VBA to Create Pivot Tables

IN THIS CHAPTER

Introducing Pivot Tables	281
Understanding Versions	281
Creating a Vanilla Pivot Table in the Excel Interface	284
Building a Pivot Table in Excel VBA	287
Creating a Report Showing Revenue by Product	294
Handling Additional Annoyances When Creating Your Final Report	298
Addressing Issues with Two or More Data Fields	305
Summarizing Date Fields with Grouping	311
Using Advanced Pivot Table Techniques	318
Controlling the Sort Order Manually	326
Using Sum, Average, Count, Min, Max, and More	327
Creating Report Percentages	328
Using New Pivot Table Features in Excel 2007	330
Next Steps	335

Introducing Pivot Tables

Pivot tables are the most powerful tools that Excel has to offer. The concept was first put into practice ...