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