PDA

View Full Version : AutoFilter and Copy - Paste



backspace20
01-19-2016, 01:33 AM
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
01-19-2016, 02:28 AM
Are the Rows Sorted in Date order?

backspace20
01-19-2016, 03:45 AM
Hi sam,
I have attached a short sample for the excel file.
cheers

SamT
01-19-2016, 04:10 AM
I changed the thread title to better attract relevant experts