consolidation of dates

[tridento]

how would you consolidate dates so you just had the month/year in excel vba?
i have a worksheet (raw data) that has date in column A, miles travelled in column B and i want to create a summary report on a seperate worksheet (report) based on month/year (mmm/yyyy) in column A, total miles travelled in column B where total miles travelled would be a sum of all the data for each month/year that had data e.g
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]miles travelled[/TD]
[/TR]
[TR]
[TD]01/02/2010[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]05/02/2010[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]03/05/2011[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]03/05/2011[/TD]
[TD]15[/TD]
[/TR]
</tbody>[/TABLE]
after the vba code is run table on report worksheet
[TABLE="width: 500"]
<tbody>[TR]
[TD]date[/TD]
[TD]total miles travelled[/TD]
[/TR]
[TR]
[TD]Feb/2010[/TD]
[TD]37[/TD]
[/TR]
[TR]
[TD]May/2011[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]

the raw data worksheet has hundreds of dates in so i just want to be able to summarise per month/year
please help i've been stuck on this for over a month

 

[VoG]

Try a Pivot Table http://www.contextures.com/xlPivot07.html

 

[tridento]

Thanks its working now
Pivot tables are so much easier i was trying to do using vba