+ Reply to Thread
Results 1 to 2 of 2

Autofilter Copy Paste

  1. #1
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Question Autofilter Copy Paste

    Hi All,

    Problem Statement: Here daily on the 'DATA' worksheet, I need to apply autofilter, then get the data in below sequence and copy to a new worksheet and also send to the Backup workbook & store there the daily work in the respective columns.

    1) Apply autofilter on 'To be Done Date' and copy: We just need to everyday take out the entire rows of the next date (tomorrow's date) value. If the left side cells are blank in the column 'E' on the tomorrow's date then we just need to write there 'No Response' before copying the data to a new worksheet.

    2) Apply autofilter on 'Response': Here we would filter the data in just two categories 'Blank' and 'Non Blank' cells, and just take out the entire rows of the non-blank values.


    Please see my codes in the attached; I'm unable to find out the further way to the destination. Here I am unable to copy the filtered data and paste into a worksheet then send the same data to the 'Backup' workbook.

    Please see the attached and help me out.

    Thanks in advance!

    MS Excel: 2007
    Attached Files Attached Files
    Last edited by SunOffice; 05-05-2011 at 09:58 PM.
    Excelforum is Completely Awesome! True learning with Live Examples & Best Techniques!!

  2. #2
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Re: Autofilter Copy Paste

    I've just tried with below codes:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by SunOffice; 05-05-2011 at 10:57 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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