Spreadsheet: 274153d1383035205-matching-data-and-copying-row-to-different-sheet-sample
Sheet: Darren

LocationID | LocationName | ConsignmentNo | ConsignmentType | VehicleNo | VehicleRegion | VehicleArea | VehicleMaxCyls | VehicleMaxWeight | VehicleType | Driver | TripKm | [NAME] | TripDate | EndDate | TotalDockets | Comments | Status | EquivalentCyls | TotalWeight | Transmit | TransmitNo | WeightOut | WeightIn
64 | AIR LIQUIDE WA PTY LTD | 20967 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 207 | 7.65 | 2013-10-01 00:00:00 | 2013-10-01 12:33:00 | 15 | metro |  | 67 | 4725.8 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 20986 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 81 | 2.483333 | 2013-10-02 00:00:00 | 2013-10-02 07:40:00 | 6 | am |  | 20 | 651.2 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 20987 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 205 | 7.9 | 2013-10-02 00:00:00 | 2013-10-02 16:08:00 | 15 | pm |  | 94 | 4998.8 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21008 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 220 | 7.516667 | 2013-10-03 00:00:00 | 2013-10-03 17:12:00 | 11 | metro 2 |  | 78 | 3948 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21007 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 110 | 4.05 | 2013-10-03 00:00:00 | 2013-10-03 09:12:00 | 7 |  |  | 42 | 3200.3 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21028 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 233 | 9.166667 | 2013-10-04 00:00:00 | 2013-10-04 14:26:00 | 17 | metro |  | 122 | 3773.6 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21027 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 1 | 0.06666667 | 2013-10-04 00:00:00 | 2013-10-04 04:53:00 | 1 | ice am |  | 0 | 703 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21040 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 263 | 8.183333 | 2013-10-07 00:00:00 | 2013-10-07 13:33:00 | 13 | metro |  | 84 | 3443 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21039 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 50 | 2 | 2013-10-07 00:00:00 | 2013-10-07 00:00:00 |  | ice am |  | 0 | 0 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21056 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 152 | 6.05 | 2013-10-08 00:00:00 | 2013-10-08 15:31:00 | 14 | METRO |  | 86 | 3829.5 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21055 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 102 | 3.933333 | 2013-10-08 00:00:00 | 2013-10-08 08:48:00 | 7 | AM ICE |  | 14 | 2906.2 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21077 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 296 | 9.15 | 2013-10-09 00:00:00 | 2013-10-09 14:22:00 | 18 | ice am |  | 119 | 5209.2 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21093 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 208 | 6.666667 | 2013-10-10 00:00:00 | 2013-10-10 15:09:00 | 15 | metro |  | 123 | 3897 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21092 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 98 | 2.966667 | 2013-10-10 00:00:00 | 2013-10-10 07:54:00 | 7 | ice |  | 9 | 2057.2 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21116 |  | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 50 | 2 | 2013-10-11 00:00:00 | 2013-10-11 00:00:00 | 17 | metro |  | 98 | 5814.6 |  |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21115 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 115 | 3.716667 | 2013-10-11 00:00:00 | 2013-10-11 08:55:00 | 5 | am ice |  | 46 | 3471.2 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21135 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 283 | 9.983334 | 2013-10-14 00:00:00 | 2013-10-14 14:19:00 | 15 | ice am/pm |  | 71 | 3295 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21152 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 163 | 6.8 | 2013-10-15 00:00:00 | 2013-10-15 15:27:00 | 14 | metro |  | 97 | 2872.8 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21151 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 90 | 3.583333 | 2013-10-15 00:00:00 | 2013-10-15 07:49:00 | 3 | am ice |  | 0 | 1434 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21169 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 244 | 9.716666 | 2013-10-16 00:00:00 | 2013-10-16 13:59:00 | 19 | metro |  | 91 | 3976 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21185 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 237 | 9.5 | 2013-10-17 00:00:00 | 2013-10-17 13:56:00 | 14 | pm consign |  | 71 | 3060 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21184 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 107 | 0.2166667 | 2013-10-17 00:00:00 | 2013-10-17 04:19:00 | 9 | am run |  | 11 | 2084.4 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21200 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 231 | 9 | 2013-10-18 00:00:00 | 2013-10-18 13:39:00 | 18 | metro |  | 100 | 5091.8 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21223 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 99 | 2.566667 | 2013-10-19 00:00:00 | 2013-10-19 06:21:00 | 2 | sat ice |  | 0 | 3002 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21222 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 232 | 10.66667 | 2013-10-21 00:00:00 | 2013-10-21 14:47:00 | 12 | metro trip 2 |  | 120 | 6035.6 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21221 |  | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 0 | 0 | 2013-10-21 00:00:00 | 2013-10-21 00:00:00 |  | metro |  | 0 | 0 |  |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21239 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 107 | 4.85 | 2013-10-22 00:00:00 | 2013-10-22 09:00:00 | 7 | ice am mmetro |  | 30 | 2737.4 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21240 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 221 | 6.466667 | 2013-10-22 00:00:00 | 2013-10-22 16:24:00 | 15 | metro |  | 106 | 4659 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21257 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 99 | 2.783333 | 2013-10-23 00:00:00 | 2013-10-23 07:45:00 | 4 | ICE |  | 14 | 817 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21258 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 151 | 7 | 2013-10-23 00:00:00 | 2013-10-23 15:34:00 | 14 | METRO |  | 133 | 5516.8 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21275 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 108 | 0.1333333 | 2013-10-24 00:00:00 | 2013-10-24 04:02:00 | 5 | ice |  | 4 | 1000.2 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21276 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 156 | 10.46667 | 2013-10-24 00:00:00 | 2013-10-24 14:44:00 | 18 | metro |  | 100 | 3452 | Y |  | 0 | 0
64 | AIR LIQUIDE WA PTY LTD | 21293 | PDT | 007 | 1BLA190 | M | 90 | 5500 | CY | [NAME] | 159 | 10.03333 | 2013-10-25 00:00:00 | 2013-10-25 14:25:00 | 16 | METRO |  | 87 | 3799 | Y |  | 0 | 0