AutoFilter and Copy - Paste

[backspace20]

I have table which the first column is dates. The dates start from 1/1/2013 (mm/dd/yyyy) to 12/29/2015 . I want to copy data base on months from this sheet to the new one. For example all Jan data from 2013,2014 and 2015 to one new sheet and all feb data from 2013,2014,2015 in another one and so on. How can I do it by advance filter? How can I define the criteria in advance filter?

Thanks

[SamT]

Are the Rows Sorted in Date order?

[backspace20]

Hi sam,
I have attached a short sample for the excel file.
cheers

[SamT]

I changed the thread title to better attract relevant experts