Excel 2010: How to Create a PivotTable from Multiple Sheets

[cks1026]

Hi all,

I got 2 sheet source of data, which it contain the details of sales order and cancelled order, both sheet have different details, different header / field.
How can I possible combine these 2 sheet data into 1 pivot table.

I'm currently using Excel 2010.

Appreciate your help.

Thanks

Regards
cks1026

[humdingaling]

Look up powerpivot
for excel 2010 it is an addin

http://chandoo.org/wp/2010/01/08/powerpivot-review/