Spreadsheet: 215398d1361369596-how-to-create-auto-populated-order-sheet-materials-requisition-sheet
Sheet: LABELS

Goods Taken from Stock | HIGHLIGHT GREEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Transferred from Stock to Job | HIGHLIGHT PINK
Goods Ordered | HIGHLIGHT BLUE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Jobs | HIGHLIGHT ORANGE
[NAME] | Description/Comment |  |  |  |  |  |  |  |  |  |  |  | Qty | Code | Supplier | Price | Total | [NAME] | Description/Comment |  |  |  |  |  |  |  |  |  |  |  | Qty | Code | Supplier | Price | Total
1A+G09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | A1 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1A-G09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | A2 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2A+G09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | A3 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2A-G09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | A4 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3A+G09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | B1 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3A-G09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | B2 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1A+G18 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | B3 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1A-G18 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | B4 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2A+G18 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | C1 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2A-G18 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | C2 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3A+G18 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | [NAME] | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3A-G18 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | C4 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1A+U21 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | E1 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1A-U21 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | E2 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2A+U21 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | F1 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2A-U21 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | F2 | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3A+U21 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | [NAME] | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3A-U21 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1A+U09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1A-U09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2A+U09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2A-U09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3A+U09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3A-U09 | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
VF VET | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
T-Mobile Labels | Description/Comment |  |  |  |  |  |  |  |  |  |  |  | Qty | Code | Supplier | Price | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C1A1 TX/RX | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C1A2 TX/RX | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C2A1 TX/RX | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C2A2 TX/RX | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C3A1 TX/RX | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C3A2 TX/RX | Red Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
uA1 TX/RX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
uA2 TX/RX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
uB2 TX/RX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
uC1 TX/RX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | [NAME] | Description/Comment |  |  |  |  |  |  |  |  |  |  |  | Qty | Code | Supplier | Price | Total
uC2 TX/RX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF1  [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
UA2 - BIAS T | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
UB2 - BIAS T | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF3 [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
UC2 - BIAS T | White Labels |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF1  [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C1A1 RX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C1A2 RX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF3 [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF1  U09 DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C2A2 RX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C3A1 RX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF3 U09 DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
C3A2 RX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF1  U09 F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
[NAME] | Description/Comment |  |  |  |  |  |  |  |  |  |  |  | Qty | Code | Supplier | Price | Total | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1U21A | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF3 U09 F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1U21P | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF1  U21 DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2U21A | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF2  U21 DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2U21P | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF3 U21 DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3U21A | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF1  U21 F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3U21P | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF2  U21 F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
4U21A | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF3 U21 F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
4U21P | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF1 [NAME] U21 DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
5U21A | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF12 [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
5U21P | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF13 [NAME] U21 DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
6U21A | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF1 [NAME] U21 F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
6U21P | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF12 G09 U09 U21 F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1U21+ | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | RF13 G09 U09 U21 F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
1U21- | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | HUAWEI FIBRE | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2U21+ | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
2U21- | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
3U21+ | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | SMTest1 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | Stores
3U21- | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
4U21+ | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
4U21- | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
5U21+ | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
5U21- | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
6U21+ | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
6U21- | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
RF-2U21-F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | REMEMBER TO ADD £30 CARRIAGE CHARGE TO ALL ANIXTER ORDERS - BIN CODE IS 3000
RF-3U21-F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | Operator/Client
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | Requested By
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | Site Name
RF-6U21-F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | Cell ID
RF-1U21-DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | Site Address
RF-2U21-DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
RF-3U21-DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
RF-4U21-DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | Delivery Address
RF-5U21-DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
RF-6U21-DC | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0
O2 VET | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4202 | GCA | 0.3 | 0 | Date Ordered
[NAME] | Description/Comment |  |  |  |  |  |  |  |  |  |  |  | Qty | Code | Supplier | Price | Total | Date Required
18 Digit Carriers | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4370 | GCA | 5.79 | 0 | Job No
12 Digit Carriers | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4371 | GCA | 4.19 | 0 | Team Leader Name
7 Digit Carriers | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 4201 | gca | 2.76 | 0 | Contact Number
Assem Mrkrs c/w Carriers & Ties Roll 500 | Vodafone and H3G |  |  |  |  |  |  |  |  |  |  |  |  | 4200 | GCA | 6.62 | 0 | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0