Copy and Paste Macro

[shawn2209]

Ok, I am need of help right here. This may be an easy one for you guys but I am stumped for right now. I have my spreadsheet identifying what is over 24 hours on one tab. I am needing that information from that row to be copied and pasted to a running list on another tab. I will give more details below.

On “Overage Tracking Running Report” I have a running list of inventory and I have off to the side what information is over 24 hours by running formula: =IF(D1>NOW()-0.1,"","DELETE ME") and so on down column N. This will put the words “DELETE ME” if information in that row is over 24 hours. I am needing the information from D,F, and G to copy and paste on a running list to “Totes Over 24 Hours” starting with A9 for Date, B9 for Tote, and C9 for Tote Location. Below is a screenshot of each tab.

“Overage Tracking Running Report”
VAS UPC Date OV # Tote Tote Location
098098 7/26/17 1:11 OV1 T1231 VAS DELETE ME
VAS UPC Date OV # Tote Tote Location
1234123 7/26/17 1:37 OV1 0 0 DELETE ME

“Totes Over 24 Hours”
Date Tote Tote Location
- - -

 

[shawn2209]

Sorry when it submitted the thread the spaces went away in the report screenshots. On "Overage Tracking report", "VAS" is in column A, UPC is in column B, Date is in column D, OV# is in column E,Tote is in column F, and Tote Location is in column G. Information below that is 098098 is in column B, 7/26/17 1:11 is in column D, OV1 is in column E, T1231 is in column F, and VAS is in column G.

For "Totes Over 24 Hours"
Date is in column A, Tote column B, and Tote Location is column C. The dashes follow suit with those columns waiting for information.