Pivot Table with Multiple sheets
 

Hi,
I need to create a pivot table from two sheets the range columns are the
same but the pivot table need to be categorize by the content of one the
column versus another one.
Find the excel spreadsheet, on the sheet 3 it's an example of how the pivot
table have to be.
I'm a novice on excel and I am not really sure I can do that without macro.

--------------------------
http://www.savefile.com/files/1861224

Thanks
Dy'

Pivot Table with Multiple sheets
 

This uses Excel 2007 and Reverse Pivot Table.
Includes update macro.
http://www.savefile.com/files/1861776

Pivot Table with Multiple sheets
 

Great work Thank You so much!! I try to understand how do you do it. But it
still confusing for me! AnyWay!! You're the Best
Cheers

"Herbert Seidenberg" wrote:

This uses Excel 2007 and Reverse Pivot Table.
Includes update macro.
http://www.savefile.com/files/1861776

Pivot Table with Multiple sheets
 

Added Notes to explain macro.
Same link.