In the attached Excel file, I have two tabs. One contains raw data, and the other contains a pivot table of the raw data.
I’m looking for an effective VBA module that will clear all filters in pivot table (ie selection criteria for column labels and row label should revert back to “Select All”) and Change Data Source range to the full range of the new RawData.
I need this to be dynamic because the number of rows in my “RawData” may vary. Here’s a link
to trigger some thought regarding this. I appreciate any expert advice anyone can give me in accomplishing this.