Spreadsheet: 42620d1241154918-look-up-to-new-sheets-createsheetsbyregion-macro
Sheet: Sheet1

Date | Job No. | Branch | Branch Name | Region | Customer | Fault | Invoice # | Invoiced | Subcontractor | Elite Order # | Elite Tech | Upgrades
24.04.09 | AK4922 | CD 129 | [NAME] | WN | 90083125 | Compactor not crushing all the way down |  | No | Hymech NZ | W7186
24.04.09 | AK4923 | CD 129 | [NAME] | WN | 90083127 | 3 x manual pallet jacks wheels are stiff not moving freely |  | No | Hymech NZ | W7187
25.04.09 | AK4924 | CD 178 | Eastgate | CH | 90083220 | C/O - Front auto roller door jammed halfway |  | No |  |  | [NAME]
25.04.09 | AK4925 | CD 148 | Nawton | AK | 90083250 | C/O - Roller door unravelled and can't be closed |  | No
27.04.09 | AK4926 | CD 123 | Pt Chevalier | AK | 90083353 | Automatic doors at front entrance are not opening or closing |  | No |  |  | [NAME]
27.04.09 | AK4927 | WW 458 | Meadowlands | AK | 90083317 | Auto bale press stopped working |  | No |  |  | [NAME]
27.04.09 | AK4928 | CD 142 | Highland Park | AK | 90083412 | Small auto baler doesn't stop when nearly full as it should |  | No |  |  | [NAME]
27.04.09 | AK4929 | FT 205 | Three Kings | AK | 90083417 | Rear roller door damaged by truck, keypad for RSD damaged as well |  | No |  |  | [NAME]
27.04.09 | AK4930 | CD 130 | Carlyle | AK | 90083431 | Entrance auto door bottom rail is broken |  | No | [NAME] | W7193
27.04.09 | AK4931 | FT 206 | [NAME] | AK | 90083448 | Butchery roller door will not close |  | No |  |  | [NAME]
27.04.09 | AK4932 | CD 197 | Sunnynook | AK | DANIE | Auto doors are scraping on floor when opening and closing |  | No |  |  | [NAME]
27.04.09 | AK4933 | CD 184 | [NAME] | CH | 90083468 | Front auto door not opening/closing properly keeps jamming |  | No |  |  | [NAME]
27.04.09 | AK4934 | CD 128 | Greenlane | AK | 90083504 | C/O - Dock leveller is not working |  | No |  |  | [NAME]
28.04.09 | AK4935 | CD 114 | [NAME] | AK | 90083539 | Manual pallet jacks x 3 require service |  | No |  |  | [NAME]
28.04.09 | AK4936 | FT 217 | [NAME] | AK | 90083554 | Entrance auto door not working at all |  | No |  |  | [NAME]
28.04.09 | AK4937 | WW 554 | Te Awamutu | AK | 90083563 | 2 x pallet jacks - 1 x handle has lost pin, 1 x bottom wheel is locking up |  | No |  |  | [NAME]
23.04.09 | AK4938 | CD 129 | [NAME] | WN | 90082908 | Auto door to unused liquor store has come off bottom rollers |  | No | Jay Hart Electrical | W7194
28.04.09 | AK4939 | FT 210 | Onehunga | AK | 90083592 | Auto bale press at the back dock is leaking oil & needs urgent repair |  | No |  |  | [NAME]
28.04.09 | AK4940 | CD 147 | Westgate | AK | 90083705 | C/O - Dock leveller is not going up |  | No |  |  | [NAME]
29.04.09 | AK4941 | CD 148 | Nawton | AK | 90083778 | Automatic doors at front entrance is not opening |  | No | Couper Doors | W7199
29.04.09 | AK4942 | FT 203 | Kelston | AK | 90083782 | Front roller door will not open at the front entrance of store |  | No |  |  | [NAME]
29.04.09 | AK4943 | WW 528 | New Plymouth | AK | 90083780 | Roller doors in carpark will not open |  | No | Laser Electrical | W7200
29.04.09 | AK4944 | FT 239 | Pukekohe | AK | 90083793 | Rear dock roller damaged by truck still works, just needs checking over |  | No |  |  | [NAME]
29.04.09 | AK4945 | WW 476 | [NAME] | CH | 90083810 | Auto bale press not operating |  | No | Aden Electrical | W7214 | [NAME]
29.04.09 | AK4946 | CD 141 | [NAME] | AK | 90083885 | Bale press door is hanging by 1 hinge, other has bolts fallen off |  | No |  |  | [NAME]
30.04.09 | AK4947 | CD 188 | Wainuiomata | WN | 90083942 | Entrance auto doors beeping and only partially opens then closes |  | No |  |  | [NAME]
30.04.09 | AK4948 | WW 549 | Massey | AK | 90084038 | Hoist sensor is damaged now only works intermittently |  | No |  |  | [NAME]
30.04.09 | AK4949 | WW 462 | Bayfair | AK | 90084043 | Power lead on the cardboard crusher needs lengthening |  | No |  |  | [NAME]
30.04.09 | AK4950 | FT 241 | Newmarket | AK | 90084045 | C/O - Back roller door won't come down |  | No |  |  | [NAME]
01.05.09 | AK4951 | CD 124 | Tikipunga | AK | 90084116 | Front entrance auto door not opening/closing properly |  | No | [NAME] | W7212