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 (Ive 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
  •