Chapter 12. Using VBA to Create Pivot Tables


IN THIS CHAPTER

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



    Pivot Table Data Crunching
    Pivot Table Data Crunching for Microsoft Office Excel 2007
    ISBN: 0789736012
    EAN: 2147483647
    Year: 2003
    Pages: 140

    Similar book on Amazon

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net