Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing 2 pivot tables data using VBA
Hi,
I have a summary data and detail data which I uses 2 pivot tables to summarize the data in the same format like below <Page field = Value1 Account Dept Ccy Amount A1 D1 USD 1000 D3 CHF 2000 D4 SGD 3000 A2 D4 USD 4000 A3 D1 USD 5000 As the amount may differ when summarized using the format abovev, I would like to loop through from one of the pivot table PivotTable1 (source is the summary data) and compare the other pivot table PivotTable2 (the detail data), using each of the columns combination. i.e. check amount of A1, D1, USD in PivotTable1 and compare to amount of A1, D1, USD in PivotTable2 Cheers, Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Source Data in Pivot Tables | Excel Worksheet Functions | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
Clearing Old data in Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables - Can I get back to my original Data | Excel Discussion (Misc queries) | |||
Putting data into pivot tables in columns not rows. | Excel Discussion (Misc queries) |