Spreadsheet: 225922d1365177313-second-drop-down-dependent-list-in-b2-under-sheet-tab-c-2nd-drop-down-dependant-list
Sheet: data

Depot | Stock Code | Stock Code 2 | Start Date | Finish Date | Per Qty | Back Value £'s | Back Value % | Credit card | Description | CENTRES SUP COD 1 | CENTRES SUP COD 2 | CENTRES SUP COD 3 | CENTRES SUP COD 4 | LTD SUP COD 1 | LTD SUP COD 2 | LTD SUP COD 3 | LTD SUP COD 4 | LB SUP COD 1 | LB SUP COD 2 | LB SUP COD 3 | LB SUP COD 4 | BEDF SUP COD 1 | BEDF SUP COD 2 | BEDF SUP COD 3 | BEDF SUP COD 4 | PG | PG L1 | PG L2 | PG L3 | unkown1 | unkown2 | Per | CENTRES SUP COD 1 QTY | CENTRES SUP COD 2 QTY | CENTRES SUP COD 3 QTY | CENTRES SUP COD 4 QTY | CENTRES SUP COD 1 QTY VALUE | CENTRES SUP COD 2 QTY VALUE | CENTRES SUP COD 3 QTY VALUE | CENTRES SUP COD 4 QTY VALUE | LTD SUP COD 1 QTY | LTD SUP COD 2 QTY | LTD SUP COD 3 QTY | LTD SUP COD 4 QTY | LTD SUP COD 1 QTY VALUE | LTD SUP COD 2 QTY VALUE | LTD SUP COD 3 QTY VALUE | LTD SUP COD 4 QTY VALUE | LB SUP COD 1 QTY | LB SUP COD 2 QTY | LB SUP COD 3 QTY | LB SUP COD 4 QTY | LB SUP COD 1 QTY VALUE | LB SUP COD 2 QTY VALUE | LB SUP COD 3 QTY VALUE | LB SUP COD 4 QTY VALUE | BEDF SUP COD 1 QTY | BEDF SUP COD 2 QTY | BEDF SUP COD 3 QTY | BEDF SUP COD 4 QTY | BEDF SUP COD 1 QTY VALUE | BEDF SUP COD 2 QTY VALUE | BEDF SUP COD 3 QTY VALUE | BEDF SUP COD 4 QTY VALUE | CENTRES TOTAL QTY | LTD TOTAL QTY | LB TOTAL QTY | BEDFORD TOTAL QTY | TOTAL QTY | TOTAL CREDIT QTY VALUE | CENTRES 1 INV VALUE | CENTRES 2 INV VALUE | CENTRES 3 INV VALUE | CENTRES 4 INV VALUE | CENTRES 1 CREDIT % VALUE | CENTRES 2 CREDIT % VALUE | CENTRES 3 CREDIT % VALUE | CENTRES 4 CREDIT % VALUE | LTD 1 INV VALUE | LTD 2 INV VALUE | LTD 3 INV VALUE | LTD 4 INV VALUE | LTD 1 CREDIT % VALUE | LTD 2 CREDIT % VALUE | LTD 3 CREDIT % VALUE | LTD 4 CREDIT % VALUE | LB 1 INV VALUE | LB 2 INV VALUE | LB 3 INV VALUE | LB 4 INV VALUE | LB 1 CREDIT % VALUE | LB 2 CREDIT % VALUE | LB 3 CREDIT % VALUE | LB 4 CREDIT % VALUE | BEDF 1 INV VALUE | BEDF 2 INV VALUE | BEDF 3 INV VALUE | BEDF 4 INV VALUE | BEDF 1 CREDIT % VALUE | BEDF 2 CREDIT % VALUE | BEDF 3 CREDIT % VALUE | BEDF 4 CREDIT % VALUE | CENTRES TOTAL INV VAL | LTD TOTAL INV VAL | LB TOTAL INV VAL | BEDFORD TOTAL INV VAL | TOTAL INV VALUE | CREDIT % VALUE | TOTAL CREDIT VALUE
20 | MA20671Y |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 | 100 | 45 | 0 | 0 | [NAME] 71 [NAME] | AE006 | AM001 | AM048 |  |  |  |  |  |  |  |  |  |  |  |  |  | A00209 | A | 002 | 09 | 0 | 2.13 | 1
20 | MA20677Y |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 | 100 | 45 | 0 | 0 | [NAME] 95 Orange | AE006 | AM001 | AM048 |  |  |  |  |  |  |  |  |  |  |  |  |  | A00209 | A | 002 | 09 | 0 | 2.13 | 1
20 | MA20695Y |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 | 100 | 45 | 0 | 0 | Silver Segmental Ridge 95 Orange | AE006 | AM001 | AM048 |  |  |  |  |  |  |  |  |  |  |  |  |  | A00209 | A | 002 | 09 | 0 | 2.13 | 1
20 | MA206BOY |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 | 100 | 45 | 0 | 0 | Silver Segmental Ridge Burnt Orange | AE006 | AM001 | AM048 |  |  |  |  |  |  |  |  |  |  |  |  |  | A00209 | A | 002 | 09 | 0 | 2.13 | 1
20 | MA21120Y |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 | 100 | 45 | 0 | 0 | Silver Ext.Angle L/H 90^ 20 Ant.Brn | AW008 | AM001 | AM048 |  |  |  |  |  |  |  |  |  |  |  |  |  | A00209 | A | 002 | 09 | 0 | 2.13 | 1
20 | MA21122Y |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 | 100 | 45 | 0 | 0 | Silver Ext.Angle L/H 90^ 22 Greystone | AE006 | AM001 | AM048 |  |  |  |  |  |  |  |  |  |  |  |  |  | A00209 | A | 002 | 09 | 0 | 2.13 | 1
20 | MA21126Y |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 | 100 | 45 | 0 | 0 | Silver Ext.Angle L/H 90^ 26 Dk.Red | AW008 | AM001 | AM048 |  |  |  |  |  |  |  |  |  |  |  |  |  | A00209 | A | 002 | 09 | 6 | 2.13 | 1
20 | MA21128Y |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 | 100 | 45 | 0 | 0 | Silver Ext.Angle L/H 90^ 28 Sm.Grey | AW008 | AM001 | AM048 |  |  |  |  |  |  |  |  |  |  |  |  |  | A00209 | A | 002 | 09 | 0 | 2.13 | 1
20 | MA21139Y |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 | 100 | 45 | 0 | 0 | Silver Ext.Angle L/H 90^ 39 Mos.Red | AW008 | AM001 | AM048 |  |  |  |  |  |  |  |  |  |  |  |  |  | A00209 | A | 002 | 09 | 0 | 2.13 | 1