multiple data sheet piovt table
 

Hello,


sheet1 name sales
sheet2 name purchase

sheet sales data below

Date Billno Party Paritcular Qty Rate Amount
1-2-12 12021 vipul r mango 25 100 2500
3-2-12 24560 mahesh vanila 20 50 1000
10-2-12 65696 hitesh sitafal 40 40 1600


sheet2 purchase data below

Date Billno Party Paritcular Qty Rate Amount
26-1-12 121 ganesh mango 50 60 3000
28-1-12 24560 ganesh vanila 40 100 4000
10-2-12 65696 ganesh sitafal 60 50 3000


now i create piovt table with multipulse sheet data so maintain stock &
amout


how