Consolidate report in Different sheet
Hi
You will need to enter - values in the the return items.
Then DataSubtotalAt each change inDateUse functionSumTick all of the boxesOK
Now if you choose View 2 from the 1,2,3 that appears below the Name box, then you will get the report you want.
Note the result is different from what you show
Day 1 cash is 4000
Day 2 cash is 11000
--
Regards
Roger Govier
"Krishna Kumar L" wrote in message ...
Hi,
I have a sheet where I collect data on a daily basis. I want to consolidate the same data in a separate sheet date wise. The details pertaining to that date should be displayed in the new sheet. Have a look at the sample and reply. I want use filters. Thanks a lot in advance.
Data collection sheet
Date Mode Route Prodcuct1 Product2 Product3 Total cash Total
1-2-09 Sales Line 1 10 10 10 Rs.3000 30
1-2-09 Sales line2 5 20 Rs.4000 15
1-2-09 return line1 5 10 -Rs.3000 -15
2-2-09 Sales Line3 10 10 10 Rs.5000 30
2-2-09 Sales Line4 50 Rs.6000 50
Consolidation sheet
Filter all columns
Date mode route product1 product2 product3 Total cash total products
1-2-09 In/out line1 10 30 0 Rs.3000 40
2-2-09 In/Out Line3 60 10 Rs.6000 70
All prices are just examples... kindly use filters and help me
Thanks
KK
|