IN THIS CHAPTER
Introduction to VBATricks of the TradeVersionsBuild a Pivot Table in Excel VBARevenue by Model for a Product Line ManagerHandle Additional AnnoyancesIssues with Two or More Data FieldsSummarize Date Fields with GroupingAdvanced Pivot Table TechniquesControl the Sort Order ManuallySum, Average, Count, Min, Max, and MoreReport Percentages
Introduction to VBA
Tricks of the Trade
Versions
Build a Pivot Table in Excel VBA
Revenue by Model for a Product Line Manager
Handle Additional Annoyances
Issues with Two or More Data Fields
Summarize Date Fields with Grouping
Advanced Pivot Table Techniques
Control the Sort Order Manually
Sum, Average, Count, Min, Max, and More
Report Percentages