+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    05-25-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    11

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

    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
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

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

    Hi,
    You will find attached a solution with Pivot Table
    When the filter is done on the pivot table, the sheet copy is automaticaly done by the options command "Display pages of report filter"
    I create the sheets Day Filter (01/10/2011) and the Month Filter with the procédure described above
    I hope this will help
    Best regards
    Attached Files Attached Files

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

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

    Here's some code that you can adapt
    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

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

    Hi,
    Arshmaan you have cross posted here
    Best regards

  5. #5
    Registered User
    Join Date
    05-25-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    11

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

    Quote Originally Posted by royUK View Post
    Here's some code that you can adapt
    Please Login or Register  to view this content.

    thanks roy for your help.. but

    Set rData = .Range(Cells(1, 1).CurrentRegion)

    Method 'Range' of object '_Worksheet' failed

    will you please let me know how to fix it my table start from A4 i have also change the value but it didn't work.. i have attached my file as well
    Last edited by Arshmaan; 12-13-2011 at 12:44 AM.

  6. #6
    Registered User
    Join Date
    05-25-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    11

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

    Quote Originally Posted by jpr73 View Post
    Hi,
    You will find attached a solution with Pivot Table
    When the filter is done on the pivot table, the sheet copy is automaticaly done by the options command "Display pages of report filter"
    I create the sheets Day Filter (01/10/2011) and the Month Filter with the procédure described above
    I hope this will help
    Best regards
    Thank you very much pivot table works for me.. thanks alot.. ya i have also post there but i didn't receive any response
    thanks to you..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1