Extract/Move row based condition

[Keysha_bee]

Hello Everyone,

I have searched this forum and others for several days but can't find what I needed so I took a stab and trying to code myself and it was an epic fail....

I have two workbooks wb1 (has master data in it) and wb2 (storage data). Here's what I'm trying to do...

-If column AA in wb1,ws1 "Jan - Aug" = "Validation Complete", cut the entire row
- Open wb2,ws2 "Sheet1", find and paste on the last row
-Loop through wb1,ws1

Here's the code I'm trying to use...

Sub Status()
Dim i As Long
Dim j As Long
Dim lastrow1 As Long
Dim lastrow2 As Long
Dim Status As String
Dim wb1 As Workbook, wb2 As Workbook
Dim ws1 As Worksheet, ws2 As Worksheet
Application.ScreenUpdating = False
Set wb2 = Workbooks.Open("C:\Users\lakeit\Desktop\Lubes Validated Data.xlsm")
Set ws2 = Sheets("Sheet1")
Set wb1 = Workbooks("All Lubes Test - Master Data.xlsm")
Set ws1 = ThisWorkbook.Sheets("Jan - Aug")
 
'Let’s start at row 2. Row 1 has headers
For i = 2 To lastrow1
For j = 2 To lastrow2
'Start the loop
'Do While Cells(i, 1).Value <> ""
'Look for data with ‘Validation’
    If wb1.Sheet("Jan - Aug").Cells(i, "AA").Value = "Validation Complete" Then
'copy the row if it contains ‘Car’
     wb1.ws1.Sheets("Jan - Aug").Range(Cells(i, "A"), Cells(i, "AI")).Cut
'Go to sheet2. Activate it. We want the data here
    wb2.ws2.Sheets("Sheet1").Activate
    
    wb2.ws2.Sheets("Sheet2").Range(Cells(j, "A"), Cells(j, "AI")).Select
'Find the first empty row in sheet2
    lastrow2 = wb2.Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
'Paste the data here
    ActiveSheet.Paste Destination:=wb2.Sheets("Sheet1").Rows(lastrow2)
   End If
   'go to sheet1 again and actvate it
wb1.ws1.Sheets("Jan - Aug").Activate
'Loop through the other rows with data
    
    Next j
    Application.CutCopyMode = False
    Next I

(I am placing a small data set here but the real version I of the master data has several worksheet with data and formulas)[TABLE="width: 500"]
<tbody>[TR]
[TD]
[TABLE="width: 4389"]
<tbody>[TR]
[TD]Invoice Number
[/TD]
[TD]Invoice Number2
[/TD]
[TD]Sold-to party
[/TD]
[TD]Shipping Date
[/TD]
[TD]Material
[/TD]
[TD]Mode of transport
[/TD]
[TD]Ship-to party
[/TD]
[TD]Dest. Country
[/TD]
[TD]Co. code
[/TD]
[TD]Billing doc. date
[/TD]
[TD]Route
[/TD]
[TD]Customs Qty 1 (Gal)
[/TD]
[TD]Sum of Invoice
[/TD]
[TD]Agent's Name
[/TD]
[TD]Concat
[/TD]
[TD]Filed w/I Time Period
[/TD]
[TD]Days
[/TD]
[TD]Night
[/TD]
[TD]Evening
[/TD]
[TD]Hazardous
[/TD]
[TD]Port
[/TD]
[TD]Destination Country
[/TD]
[TD]Type
[/TD]
[TD]Volume
[/TD]
[TD]Value
[/TD]
[TD]Freight
[/TD]
[TD]Status
[/TD]
[/TR]
[TR]
[TD]246559839
[/TD]
[TD]967035861
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1058899
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]2420
[/TD]
[TD]16020.4
[/TD]
[TD]Off
[/TD]
[TD]246559839-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559839
[/TD]
[TD]967035861
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1057265
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]550
[/TD]
[TD]3300
[/TD]
[TD]Off
[/TD]
[TD]246559839-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559839
[/TD]
[TD]967035861
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1042786
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]262.629
[/TD]
[TD]2489.2
[/TD]
[TD]Off
[/TD]
[TD]246559839-2710193040
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559839
[/TD]
[TD]967035861
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1058870
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]140
[/TD]
[TD]1118.6
[/TD]
[TD]Off
[/TD]
[TD]246559839-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559839
[/TD]
[TD]967035861
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1055933
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]1320
[/TD]
[TD]9385.2
[/TD]
[TD]Off
[/TD]
[TD]246559839-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559839
[/TD]
[TD]967035861
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1056544
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]9.358
[/TD]
[TD]212.45
[/TD]
[TD]Off
[/TD]
[TD]246559839-2710193750
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559839
[/TD]
[TD]967035861
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1056664
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]288
[/TD]
[TD]3736.8
[/TD]
[TD]Off
[/TD]
[TD]246559839-2710193750
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559839
[/TD]
[TD]967035861
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1056667
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]233.333
[/TD]
[TD]3272.5
[/TD]
[TD]Off
[/TD]
[TD]246559839-2710193750
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1057236
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]36
[/TD]
[TD]391.68
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1058912
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]40
[/TD]
[TD]339.6
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1057265
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]2915
[/TD]
[TD]17490
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1058840
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]220
[/TD]
[TD]1870
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1062630
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]33
[/TD]
[TD]368.94
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1052775
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]72
[/TD]
[TD]586.08
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1045735
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]140
[/TD]
[TD]1358
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1055934
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]280
[/TD]
[TD]2088.8
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1055907
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]440
[/TD]
[TD]3418.8
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1057408
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]220.727
[/TD]
[TD]2058.2
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1055911
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]220
[/TD]
[TD]1709.4
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1056801
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]70
[/TD]
[TD]561.4
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1055927
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]220
[/TD]
[TD]1564.2
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1045856
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]39
[/TD]
[TD]500.37
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193080
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Value Incorrect
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1056544
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]18.717
[/TD]
[TD]424.9
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193750
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246559840
[/TD]
[TD]967040172
[/TD]
[TD]10004828
[/TD]
[TD]1/7/2016
[/TD]
[TD]1056664
[/TD]
[TD]Truck
[/TD]
[TD]20029110
[/TD]
[TD]CR
[/TD]
[TD]LL
[/TD]
[TD]1/11/2016
[/TD]
[TD]May LOGISTICS INC
[/TD]
[TD]288
[/TD]
[TD]3736.8
[/TD]
[TD]Off
[/TD]
[TD]246559840-2710193750
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]Validation Incomplete
[/TD]
[/TR]
[TR]
[TD]246588684
[/TD]
[TD]967053236
[/TD]
[TD]10083367
[/TD]
[TD]1/11/2016
[/TD]
[TD]1058900
[/TD]
[TD]Truck
[/TD]
[TD]20069222
[/TD]
[TD]AU
[/TD]
[TD]LL
[/TD]
[TD]1/12/2016
[/TD]
[TD]CH
[/TD]
[TD]420
[/TD]
[TD]2520
[/TD]
[TD]Off
[/TD]
[TD]246588684-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]246588684
[/TD]
[TD]967053236
[/TD]
[TD]10083367
[/TD]
[TD]1/11/2016
[/TD]
[TD]1057228
[/TD]
[TD]Truck
[/TD]
[TD]20069222
[/TD]
[TD]AU
[/TD]
[TD]LL
[/TD]
[TD]1/12/2016
[/TD]
[TD]CH
[/TD]
[TD]108
[/TD]
[TD]1150.2
[/TD]
[TD]Off
[/TD]
[TD]246588684-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]246588684
[/TD]
[TD]967053236
[/TD]
[TD]10083367
[/TD]
[TD]1/11/2016
[/TD]
[TD]1071515
[/TD]
[TD]Truck
[/TD]
[TD]20069222
[/TD]
[TD]AU
[/TD]
[TD]LL
[/TD]
[TD]1/12/2016
[/TD]
[TD]CH
[/TD]
[TD]220
[/TD]
[TD]1210
[/TD]
[TD]Off
[/TD]
[TD]246588684-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]246588684
[/TD]
[TD]967053236
[/TD]
[TD]10083367
[/TD]
[TD]1/11/2016
[/TD]
[TD]1061893
[/TD]
[TD]Truck
[/TD]
[TD]20069222
[/TD]
[TD]AU
[/TD]
[TD]LL
[/TD]
[TD]1/12/2016
[/TD]
[TD]CH
[/TD]
[TD]600
[/TD]
[TD]4362
[/TD]
[TD]Off
[/TD]
[TD]246588684-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]246588684
[/TD]
[TD]967053236
[/TD]
[TD]10083367
[/TD]
[TD]1/11/2016
[/TD]
[TD]1057266
[/TD]
[TD]Truck
[/TD]
[TD]20069222
[/TD]
[TD]AU
[/TD]
[TD]LL
[/TD]
[TD]1/12/2016
[/TD]
[TD]CH
[/TD]
[TD]210
[/TD]
[TD]1526.7
[/TD]
[TD]Off
[/TD]
[TD]246588684-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]246588684
[/TD]
[TD]967053236
[/TD]
[TD]10083367
[/TD]
[TD]1/11/2016
[/TD]
[TD]1071516
[/TD]
[TD]Truck
[/TD]
[TD]20069222
[/TD]
[TD]AU
[/TD]
[TD]LL
[/TD]
[TD]1/12/2016
[/TD]
[TD]CH
[/TD]
[TD]210
[/TD]
[TD]1239
[/TD]
[TD]Off
[/TD]
[TD]246588684-2710193020
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]246588684
[/TD]
[TD]967053236
[/TD]
[TD]10083367
[/TD]
[TD]1/11/2016
[/TD]
[TD]1048943
[/TD]
[TD]Truck
[/TD]
[TD]20069222
[/TD]
[TD]AU
[/TD]
[TD]LL
[/TD]
[TD]1/12/2016
[/TD]
[TD]CH
[/TD]
[TD]19.697
[/TD]
[TD]1617
[/TD]
[TD]Off
[/TD]
[TD]246588684-2710193040
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Wrong Port
[/TD]
[TD]OK
[/TD]
[TD]OK
[/TD]
[TD]Volume Incorrect
[/TD]
[TD]OK
[/TD]
[TD]TRUE
[/TD]
[TD]#N/A
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Keysha_bee]

Have you tried it with a file not on the network drive?

Yes, and it worked.