Create Pivot Tables Using VBA

MS Excel - Create Pivot Tables Using VBA

Introduction to VBA Enable VBA in Your Copy of Excel Visual Basic Editor Visual Basic Tools The Macro Recorder Understanding Object-Oriented Code Tricks of the Trade Write Code to Handle Any Size Data Range End+Down Versus End+Up Use Super-VariablesObject Variables Versions Build a Pivot Table in Excel VBA Getting a Sum Instead of a Count Cannot Move or Change Part of a Pivot Report Size of a Finished Pivot Table Revenue by Model for a Product Line Manager Eliminate Blank Cells in the Data Area Control the Sort Order with AutoSort Default Number Format Suppress Subtotals for Multiple Row Fields Suppress Grand Total for Rows Handle Additional Annoyances New Workbook to Hold the Report Summary on a Blank Report Worksheet Fill Outline View Final Formatting Add Subtotals Put It All Together Issues with Two or More Data Fields Calculated Data Fields Calculated Items Summarize Date Fields with Grouping Group by Week Advanced Pivot Table Techniques AutoShow Feature to Produce Executive Overviews ShowDetail to Filter a Recordset Create Reports for Each Region or Model Manually Filter Two or More Items in a PivotField Control the Sort Order Manually Sum, Average, Count, Min, Max, and More Report Percentages Percentage of Total Percentage Growth from Previous Month Percentage of a Specific Item Running Total Special Considerations for Excel 97

Version 5 of Excel introduced a powerful new macro language called Visual Basic for Application (VBA). Every copy of Excel shipped since 1993 has had a copy of the powerful VBA language hiding behind the worksheets.

[Next]