Jeremy asks Is there a way to select multiple headings and change all of their “Summarize value field by” at once? I have hundreds of headings, each time I want to change their value by Max, Min, Average, I have to select one heading at a time, it is extremely labor intensive. Is there a way to change field calculation for multiple headings at once?

This episode shows some simple VBA to do this quickly.

How to create a personal macro workbook: https://www.youtube.com/watch?v=ld2SU2zJvHA

Table of Contents
(0:00) Welcome
(0:41) VBA
(1:55) Looping each field
(2:35) Copying for Sum, Max, Min
(3:10) Other calculations
(3:42) Easier way to run
(4:30) Running all 4 macros
(5:25) Upcoming Webinar