Skip to Main Content
Excel Macros For Dummies
book

Excel Macros For Dummies

by Michael Alexander
June 2015
Beginner content levelBeginner
288 pages
5h 27m
English
For Dummies
Content preview from Excel Macros For Dummies

Chapter 8

Automating Common Reporting Tasks

In This Chapter

arrow Refreshing pivot tables with macros

arrow Leveraging macros to format pivot tables

arrow Applying pivot table restrictions

arrow Printing and exporting pivot data

arrow Resizing and aligning charts

arrow Exporting a set of disconnected charts

arrow Printing all charts on a worksheet

For those of us tasked with building dashboards and reports, PivotTables and charts are a daily part of our work life. Few of us have had the inclination to automate any aspect of these reporting tools with macros. But some aspects of our work lend themselves to a bit of automation. In this chapter, you explore a handful of macros that can help you save time and gain efficiencies when working with pivot tables and charts.

Refreshing All Pivot Tables in a Workbook

It’s not uncommon ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Macros For Dummies, 3rd Edition

Excel Macros For Dummies, 3rd Edition

Dick Kusleika

Publisher Resources

ISBN: 9781119089346