Macro to filter data monthwise

Hi Experts,

I have collective data based on different dates. The format of the date is "Month,date,year"
There are 4 columns such as John, Peter, Alan & Thomas for which i need the data to be filtered month wise.First column has dates.
For eg: For John I require the total count for the month say "June" .similarly for Peter, Alan and Thomas I need the total count.

I tried with Pivot table but not able to sort monthwise.

I have attached a sample workbook.And hope my requirement is clear.
Please provide me a solution.

Hi slvdin,

I did a pivot table. See if this isn't what you want.

Hi,

You need to find the GROUP BY feature of pivot tables. Watch the video at http://www.howcast.com/videos/20109-...oft-Excel-2003 to see how.