Tool to automatically combine many large pivot table in many large Excel sheet?

Question

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

Solution

This is the way I use to go around with this :

• Convert those Excel files (with the same structure pivot) to CSV

• Import to some MSSQL DB

• In my consolidated Excel, I just use MSSQL as an external datasource for it

It's a bit manual but it's the best way I know for now :)

Welcome any other suggestions

Comments

[DaveParillo]

Are you looking for a 'click around in excel solution' or is a macro solution OK?