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