Pivot Table Data Crunching for Microsoft® Office Excel® 2007

Chapter 11. Using VBA to Create Pivot Tables

<feature><title>In This Chapter</title>

• Introducing VBA 231

• Learning Tricks of the Trade 234

• Understanding Versions 236

• Building a Pivot Table in Excel VBA 239

• Creating a Report Showing Revenue by Product 246

• Handling Additional Annoyances When Creating Your Final Report 250

• Addressing Issues with Two or More Data Fields 257

• Summarizing Date Fields with Grouping 263

• Using Advanced Pivot Table Techniques 267

• Controlling the Sort Order Manually 276

• Using Sum, Average, Count, Min, Max, and More 276

• Creating Report Percentages 277

• Using New Pivot Table Features in Excel 2007 279

• Next Steps 289

</feature>

Introducing VBA

Version 5 of Excel introduced a powerful new macro language called Visual Basic for Applications (VBA). ...