Thank you in advance to anyone that helps. I've been searching the forum for hours and I can't find what I need. I uploaded a zip file with the workbook I'm using. My workbook contains 3 sheets tilted Daily DCPMR Failures, Preventable Failures and No Arrival At Unit Scan.
Based upon the sample data in the Daily DCPMR Failures sheet, I need a macro that will copy certain portions of the data from the Daily DCPMR Failures sheet into the other two sheets, based upon certain conditions.
For the 1st condition, if you look in the Daily DCPMR Failures sheet, and go to B7, you will notice that it has a 03, if the next row below that witch would be B8 does not contain a 07, then I would want the data from A8, E8 and F8 copied and pasted into the 1st available blank row in the No Arrival At unit Sheet.
The second condition would be if the date of delivery does not match the date it arrived at unit. For example, in the Daily DCPMR Failures sheet in cell D5, it arrived at unit on 11/27/2008(the time should be ignored) but it was delivered on 11/28/2007 cell D6.
In this example since the day of delivery does not match, I would like the data from cells
A6, E6 and F6 copied and pasted into the 1st available blank row in the Preventable failure sheet.
I do this on a daily basis by looking at every single row of data and copying the data into the appropriate sheet. With several thousand rows to do, it takes hours and hours. Any help on this would greatly be appreciated.
Thank you to all.