Thank Yu Don appreciate your help, But can we do such a task
Programmatically...?

"Don Guillett" wrote:

It need not be that hard.
Select your rangedatasubtotalsclear all when through

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Christien" wrote in message
...
Dear Freinds
I am new to this world but i hope that i could get some help
I Have data listed in sheet called Data as follows:
DateSales ItemSold Dtl1 Dtl2 Dtl3 T-Price Quantity
01.01.2010 Item1 60 6
01.01.2010 Item2 80 4
01.01.2010 Item3 90 2
02.01.2010 Item4 100 50
02.01.2010 Item5 150 6
09.01.2010 Item6 70 2
09.01.2010 Item7 25 5
01.02.2010 Item8 50 2
01.02.2010 Item9 130 3

etc.....

where itemSold can not be a duplicate
i would like to produce a monthy report based on criteria entered in a
cell
in Sheet Called Report (Same Workbook)
that should look like this
ItemSold DateSales Dtl1 Dtl2 Dtl3 T-Price Quantity
Item1 01.01.2010 60 6
Item2 01.01.2010 80 4
Item3 01.01.2010 90 2
01.01.2010 Total 230 12
Item4 02.01.2010 100 50
Item5 02.01.2010 150 6
02.01.2010 Total 250 56
Item6 09.01.2010 70 2
Item7 09.01.2010 25 5
09.01.2010 Total 95 7

Gtotal Per Month 575 75

.