Copy each advance filtered data (filter by date 1 to 31) to new sheet

[Arshmaan]

Hello all,

I have a my employees monthly tracking report in excel worksheet and I have to do some advance filter on each date (1 to 31 except Sundays). I am doing these steps manullay:-

1) Do Advance filter (I’ve done some VBA work). For example I filter data by date 1st, so that my code filter data by date one and remove duplicates from column “f” as well.

2) Copy the filtered data.

3) Paste it on a new sheet.

I want to do this Via VBA.. or any suitable way.. please help… I am attaching my sheet as well from which you can understand my code and update it according to my need..

[Aflatoon]

Crossposted here (http://www.excelguru.ca/forums/showthread.php?623-Copy-each-filtered-location-by-date-to-another-sheet&p=3025#post3025) and here (http://www.mrexcel.com/forum/showthread.php?t=597859) and here (http://www.excelforum.com/showthread.php?t=804907&highlight=).

[Arshmaan]

so what should i do

[GTO]

I would suggest reading Here (http://www.excelguru.ca/node/7).

[Arshmaan]

when will i got the needful ??