Pivot Table with Multiple sheets

D

Dynamite

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.
 
D

Dynamite

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table using data from multiple sheets 1
Pre-configuring Pivot table "views" 4
Pivot Tables by Macro 2
pivot table 1
Pivot Table Macro 1
Merge 2 datasheets into single Pivot Table. 2
Link Drop Down with Pivot Table 2
Pivot Table - copy specified Grand Totals 1

Top