Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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..
    Attached Files Attached Files

  2. #2
    Seeker jpr73's Avatar
    Join Date
    Apr 2011
    Location
    France
    Posts
    15
    Articles
    0
    Hi,
    Arshmaan you have cross posted here
    Best regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •