Hi
I have two pivot tables in two separate sheets in the same workbook. Bothe tables have the same column headers and page fields etc just different data
I want to create third table in another sheet that combines the data from the other two pivot tables and sums the counts from the source tables into the target table.
Any ideas please?
I have two pivot tables in two separate sheets in the same workbook. Bothe tables have the same column headers and page fields etc just different data
I want to create third table in another sheet that combines the data from the other two pivot tables and sums the counts from the source tables into the target table.
Any ideas please?