0
1
We have several Excel files that contains large pivot data table with the same structure
For example
File A
Pivot table (Field A, B, C)
File B
Pivot table (Field A, B, C)
We want to combine them into 1 pivot table (A, B, C). Just want to know which ways we can do it ?
Manual way : open a new empty sheet, copy and paste the pivot there and create the pivot again
Automatic way : is there some tool that did this ?
Thanks
Are you looking for a 'click around in excel solution' or is a macro solution OK? – DaveParillo – 2009-11-12T05:12:55.697