Macro to Repeat Item Labels in Excel Pivot and Flatten
I often use pivot tables to summarise one data source so that I can use that pivot table output as the basis for further analysis.
macro
A collection of 3 posts
Filter Pivot Table Based on Results of Another Pivot
This post demonstrates how to use VBA to alter the filters on a pivot table based on the values in another pivot table or list.
How to change multiple pivot table fields to Sum Function
The Pivot table is an incredibly powerful tool for summarising data. Excel will either default to summing or counting the field data but you can choose from 11 different functions that include min, max and StdDev as well as the...