• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Enhancing Your Pivot Table R... > Why Use Macros with Your Pivot Table...

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 back on command. In other words, you can record your actions in a macro, save the macro, and then allow your clients to play back your actions with a touch of a button. It would be as though you were there with them! This functionality is especially useful when distributing pivot table reports.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint