Pivot Table Data Crunching

11. Enhancing Your Pivot Table Reports with Macros

In this Chapter

Why Use Macros with Your Pivot Table Reports? 185

Recording Your First Macro 186

Creating a User Interface with Form Controls 187

Altering a Recorded Macro to Add Functionality 189

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 the top 20 records, group by months, or sort by revenue—even all at the same time. The fact is that you can do just that by using Excel macros.

A macro is a series of keystrokes that have been recorded and saved. Once saved, the macro can be played ...