Spreadsheet: 189240d1351126046-help-with-vlookup-macro-based-on-cell-value-referencing-tab-name-and-then-hiding-blank-rows-01-test-tracker
Sheet: 1

LOAD # | TYPE | ZONE / DESTINATION | BILLER INITIALS | STATIC (Y/N) | WINDOW DATE | WINDOW TIME | PACKET ARRIVAL TIME | SPOT # | SCAC | TRAILER # | BOL # | CXLD or XTRA | DATE BILLED | TIME BILLED | TMS # | DATE OF PU | TIME OF PU | VNU (Y/N) | LINES | COMMENTS | LOGTECH INITIALS
2Z1 | ZONE 2 | 2 |  | Y | 2012-10-01 00:00:00 | 18:00:00 |  |  |  |  |  |  |  |  | M417694
2Z2 |  | 2 |  | Y | 2012-10-01 00:00:00 | 19:00:00 |  |  |  |  |  |  |  |  | M417701
2Z3 |  | 2 |  | Y | 2012-10-01 00:00:00 | 21:00:00 |  |  |  |  |  |  |  |  | M417706
2Z4 |  | 2 |  | Y | 2012-10-01 00:00:00 | 23:29:00 |  |  |  |  |  |  |  |  | [NAME]
2Z5 |  | 2 |  | Y | 2012-10-02 00:00:00 | 02:00:00 |  |  |  |  |  |  |  |  | M417676
2Z6 |  | 2 |  | Y | 2012-10-02 00:00:00 | 05:00:00 |  |  |  |  |  |  |  |  | M417685
2Z7 |  | 2 |  | Y | 2012-10-02 00:00:00 | 05:00:00 |  |  |  |  |  |  |  |  | M417689
2Z8 |  | 2 |  | Y | 2012-10-02 00:00:00 | 06:00:00 |  |  |  |  |  |  |  |  | M417766
2Z9 |  | 2
2Z10 |  | 2
2Z11 |  | 2
2Z12 |  | 2
2Z13 |  | 2
2Z14 |  | 2
7Z1 | ZONE 7 | 7 |  | Y | 2012-10-01 00:00:00 | 19:00:00 |  |  |  |  |  |  |  |  | M421674
7Z2 |  | 7 |  | Y | 2012-10-01 00:00:00 | 21:00:00 |  |  |  |  |  |  |  |  | M421679
7Z3 |  | 7 |  | Y | 2012-10-01 00:00:00 | 21:00:00 |  |  |  |  |  |  |  |  | M421685
7Z4 |  | 7 |  | Y | 2012-10-01 00:00:00 | 22:00:00 |  |  |  |  |  |  |  |  | M421690
7Z5 |  | 7 |  | Y | 2012-10-01 00:00:00 | 23:29:00 |  |  |  |  |  |  |  |  | M421695
7Z6 |  | 7 |  | Y | 2012-10-02 00:00:00 | 05:00:00 |  |  |  |  |  |  |  |  | M421659
7Z7 |  | 7 |  | Y | 2012-10-02 00:00:00 | 05:00:00 |  |  |  |  |  |  |  |  | [NAME]
7Z8 |  | 7 |  | Y | 2012-10-02 00:00:00 | 05:00:00 |  |  |  |  |  |  |  |  | M421669
7Z9 |  | 7
7Z10 |  | 7
7Z11 |  | 7
7Z12 |  | 7
7Z13 |  | 7
7Z14 |  | 7
30Z1 | ZONE 30 | 30 |  | Y | 2012-10-01 00:00:00 | 20:00:00 |  |  |  |  |  |  |  |  | M422311
30Z2 |  | 30 |  | Y | 2012-10-01 00:00:00 | 22:00:00 |  |  |  |  |  |  |  |  | M422316
30Z3 |  | 30 |  | Y | 2012-10-01 00:00:00 | 23:30:00 |  |  |  |  |  |  |  |  | M422276
30Z4 |  | 30 |  | Y | 2012-10-01 00:00:00 | 23:30:00 |  |  |  |  |  |  |  |  | M422281
30Z5 |  | 30 |  | Y | 2012-10-02 00:00:00 | 04:00:00 |  |  |  |  |  |  |  |  | M421711
30Z6 |  | 30 |  | Y | 2012-10-02 00:00:00 | 05:00:00 |  |  |  |  |  |  |  |  | M421701
30Z7 |  | 30 |  | Y | 2012-10-02 00:00:00 | 05:00:00 |  |  |  |  |  |  |  |  | M421707
30Z8 |  | 30 |  | Y | 2012-10-02 00:00:00 | 05:00:00 |  |  |  |  |  |  |  |  | M421717
30Z9 |  | 30
30Z10 |  | 30
30Z11 |  | 30
30Z12 |  | 30
30Z13 |  | 30
30Z14 |  | 30
91Z1 | ZONE 91 | 91 |  | Y | 2012-10-01 00:00:00 | 16:00:00 |  |  |  |  |  |  |  |  | [NAME]
91Z2 |  | 91 |  | Y | 2012-10-01 00:00:00 | 19:00:00 |  |  |  |  |  |  |  |  | M421816
91Z3 |  | 91 |  | Y | 2012-10-01 00:00:00 | 21:00:00 |  |  |  |  |  |  |  |  | M421821
91Z4 |  | 91 |  | Y | 2012-10-01 00:00:00 | 23:00:00 |  |  |  |  |  |  |  |  | M421826
91Z5 |  | 91 |  | Y | 2012-10-01 00:00:00 | 23:00:00 |  |  |  |  |  |  |  |  | M421831
91Z6 |  | 91 |  | Y | 2012-10-02 00:00:00 | 03:00:00 |  |  |  |  |  |  |  |  | M421806
91Z7 |  | 91
91Z8 |  | 91
91Z9 |  | 91
91Z10 |  | 91
91Z11 |  | 91
91Z12 |  | 91
91Z13 |  | 91
91Z14 |  | 91
94Z1 | ZONE 94 | 94 |  | Y | 2012-10-01 00:00:00 | 19:00:00 |  |  |  |  |  |  |  |  | M421858
94Z2 |  | 94 |  | Y | 2012-10-01 00:00:00 | 19:00:00 |  |  |  |  |  |  |  |  | M421864
94Z3 |  | 94 |  | Y | 2012-10-01 00:00:00 | 19:00:00 |  |  |  |  |  |  |  |  | M421869
94Z4 |  | 94 |  | Y | 2012-10-01 00:00:00 | 19:00:00 |  |  |  |  |  |  |  |  | M421874
94Z5 |  | 94 |  | Y | 2012-10-01 00:00:00 | 22:00:00 |  |  |  |  |  |  |  |  | M421879
94Z6 |  | 94 |  | Y | 2012-10-01 00:00:00 | 22:00:00 |  |  |  |  |  |  |  |  | M421884
94Z7 |  | 94
94Z8 |  | 94
94Z9 |  | 94
94Z10 |  | 94
94Z11 |  | 94
94Z12 |  | 94
94Z13 |  | 94
94Z14 |  | 94
94Z15 |  | 94
94Z16 |  | 94
94Z17 |  | 94
94Z18 |  | 94
94Z19 |  | 94
94Z20 |  | 94
94Z21 |  | 94
94Z22 |  | 94
94Z23 |  | 94
94Z24 |  | 94
94Z25 |  | 94
101Z1 | ZONE 101 | 101
101Z2 |  | 101
101Z3 |  | 101
101Z4 |  | 101
101Z5 |  | 101
101Z6 |  | 101
101Z7 |  | 101
101Z8 |  | 101
101Z9 |  | 101
101Z10 |  | 101
101Z11 |  | 101
101Z12 |  | 101
101Z13 |  | 101
101Z14 |  | 101
101Z15 |  | 101
101Z16 |  | 101
101Z17 |  | 101
101Z18 |  | 101
101Z19 |  | 101
101Z20 |  | 101
101Z21 |  | 101
101Z22 |  | 101
101Z23 |  | 101
101Z24 |  | 101
101Z25 |  | 101
101Z26 |  | 101
101Z27 |  | 101
101Z28 |  | 101
101Z29 |  | 101
101Z30 |  | 101
101Z31 |  | 101
101Z32 |  | 101
101Z33 |  | 101
101Z34 |  | 101
101Z35 |  | 101
101Z36 |  | 101
101Z37 |  | 101
101Z38 |  | 101
101Z39 |  | 101
101Z40 |  | 101
T1 | PLANT TRANSFERS | XFR
T2 |  | XFR
T3 |  | XFR
T4 |  | XFR
T5 |  | XFR
T6 |  | XFR
T7 |  | XFR
T8 |  | XFR
T9 |  | XFR
T10 |  | XFR
HPO1 | HOT PROD. ORDER | HPO
HPO2 |  | HPO
HPO3 |  | HPO
HPO4 |  | HPO
HPO5 |  | HPO
HPO6 |  | HPO
HPO7 |  | HPO
HPO8 |  | HPO
S1 | SCRAP | SCRP
S2 |  | SCRP
S3 |  | SCRP
[NAME] |  | SCRP
S5 |  | SCRP
V1 | VINTAGE | VNTG
V2 |  | VNTG
V3 |  | VNTG
V4 |  | VNTG
V5 |  | VNTG
72Z1 | ZONE 72 | 72
72Z2 |  | 72
72Z3 |  | 72
72Z4 |  | 72
72Z5 |  | 72
72Z6 |  | 72
72Z7 |  | 72
72Z8 |  | 72
72Z9 |  | 72
72Z10 |  | 72
72Z11 |  | 72
72Z12 |  | 72
72Z13 |  | 72
72Z14 |  | 72
72Z15 |  | 72
72Z16 |  | 72
72Z17 |  | 72
72Z18 |  | 72
72Z19 |  | 72
72Z20 |  | 72
81Z1 | ZONE 81 | 81
81Z2 |  | 81
81Z3 |  | 81
81Z4 |  | 81
81Z5 |  | 81
81Z6 |  | 81
81Z7 |  | 81
81Z8 |  | 81
81Z9 |  | 81
81Z10 |  | 81
81Z11 |  | 81
81Z12 |  | 81
81Z13 |  | 81
81Z14 |  | 81
81Z15 |  | 81