11. Enhancing Pivot Table Reports with Macros
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 The fact is you can do just that by using Excel macros.
A macro is a series of keystrokes that have been recorded and saved. After ...
Get Pivot Table Data Crunching: Microsoft® Excel® 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
