Results 1 to 2 of 2

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

  1. #1
    Seeker Arshmaan's Avatar
    Join Date
    Oct 2011
    Location
    Pakistan
    Posts
    10
    Articles
    0
    Excel Version
    2007, 2016

    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
  •