Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
presenting data on multiple sheet on one consolidated sheet | Excel Worksheet Functions | |||
Piovt table refresh | Setting up and Configuration of Excel | |||
Compilation sheet representing multiple data from multiple other s | Excel Discussion (Misc queries) | |||
Multiple sheet Pivot table | Excel Discussion (Misc queries) | |||
Piovt Table-Drill Down Numbers lose Currency Format | Excel Discussion (Misc queries) |