Pivot Table Data Crunching for Microsoft® Office Excel® 2007

Chapter 10. Enhancing Your Pivot Table Reports with Macros

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

• Why Use Macros with Your Pivot Table Reports? 215

• Recording Your First Macro 216

• Creating a User Interface with Form Controls 218

• Altering a Recorded Macro to Add Functionality 220

• Case Study: Synchronizing Two Pivot Tables with One Combo Box 225

• Next Steps 229

</feature>

Why Use Macros with Your Pivot Table Reports?

Imagine that you could be in multiple locations at one time, with multiple clients at one time, helping them with their pivot table reports. Suppose you could help multiple clients refresh their data, extract top 20 records, group by months, or sort by revenue—all at the same time. The fact is you can do just that by using Excel macros.

A macro ...