Hi there,
I've created a spreadsheet that consists of 2 pivot tables that drilldown into 2 individual lists of customer reference numbers based on the individual pivot table report filters. Due to the report filters selected some customer references numbers can be duplicated in either pivot table drilldown. Is there anyway for a macro to automatically dedupe the raw data from both pivot tables so I only get one list of unique customer reference numbers? I understand that you can copy and paste the results from each pivot table then use data remove duplicates however I need something more automatic for the end users.
TIA
I've created a spreadsheet that consists of 2 pivot tables that drilldown into 2 individual lists of customer reference numbers based on the individual pivot table report filters. Due to the report filters selected some customer references numbers can be duplicated in either pivot table drilldown. Is there anyway for a macro to automatically dedupe the raw data from both pivot tables so I only get one list of unique customer reference numbers? I understand that you can copy and paste the results from each pivot table then use data remove duplicates however I need something more automatic for the end users.
TIA
