Spreadsheet: 101792d1299837246-using-a-drop-down-box-to-fill-a-cell-experimental-stock-movement-sheet
Sheet: Stock Movement

Period / WK | Date | Product No. | Item Description | Issued Stock | Deliveries & Returns | Running Stock | Qty To Order
Period 10 | 2010-12-31 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 16 |  | 303 | 135
Period 10 | 2011-01-02 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 10 | 2011-01-02 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 10 | 2011-01-05 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 2 |  | 303 | 135
Period 10 | 2011-01-06 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 10 | 2011-01-07 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 10 | 2011-01-12 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 4 |  | 303 | 135
Period 10 | 2011-01-18 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 4 |  | 303 | 135
Period 10 | 2011-01-18 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 10 | 2011-01-20 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 12 |  | 303 | 135
Period 10 | 2011-01-21 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 10 | 2011-01-22 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 10 | 2011-01-22 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 10 | 2011-01-25 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 10 | 2011-01-02 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 12 |  | 197 | 310
Period 10 | 2011-01-12 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 3 |  | 197 | 310
Period 10 | 2011-01-17 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 2 |  | 197 | 310
Period 10 | 2011-01-18 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 24 |  | 197 | 310
Period 10 | 2011-01-22 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 6 |  | 197 | 310
Period 10 | 2011-01-22 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 6 |  | 197 | 310
Period 10 | 2011-01-05 00:00:00 | 003 | 7 Watt GU10 Energy Saver | 2 |  | 0 | -4
Period 10 | 2011-01-18 00:00:00 | 003 | 7 Watt GU10 Energy Saver | 2 |  | 0 | -4
Period 10 | 2011-01-02 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 10 |  | 70 | 427
Period 10 | 2011-01-02 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 3 |  | 70 | 427
Period 10 | 2011-01-05 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 10 |  | 70 | 427
Period 10 | 2011-01-05 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 8 |  | 70 | 427
Period 10 | 2011-01-12 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp |  | 250 | 70 | 427
Period 10 | 2011-01-14 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 10 |  | 70 | 427
Period 10 | 2011-01-15 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 10 |  | 70 | 427
Period 10 | 2011-01-17 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 2 |  | 70 | 427
Period 10 | 2011-01-26 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 60 |  | 70 | 427
Period 10 | 2011-01-02 00:00:00 | 005 | 25 Watt SES Clear Oven Lamp | 2 |  | 401 | -11
Period 10 | 2011-01-22 00:00:00 | 005 | 25 Watt SES Clear Oven Lamp | 10 |  | 401 | -11
Period 11 | 2011-01-29 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 30 |  | 303 | 135
Period 11 | 2011-01-31 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 11 | 2011-02-03 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 18 |  | 303 | 135
Period 11 | 2011-02-04 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 1 |  | 303 | 135
Period 11 | 2011-02-04 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 24 |  | 303 | 135
Period 11 | 2011-02-06 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 24 |  | 303 | 135
Period 11 | 2011-02-07 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 12 |  | 303 | 135
Period 11 | 2011-02-08 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 18 |  | 303 | 135
Period 11 | 2011-02-13 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 11 | 2011-02-14 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 12 |  | 303 | 135
Period 11 | 2011-02-14 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 36 |  | 303 | 135
Period 11 | 2011-02-16 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 303 | 135
Period 11 | 2011-02-18 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 21 |  | 303 | 135
Period 11 | 2011-02-18 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone |  | 300 | 303 | 135
Period 11 | 2011-02-24 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 48 |  | 303 | 135
Period 11 | 2011-01-28 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 3 |  | 197 | 310
Period 11 | 2011-01-31 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 6 |  | 197 | 310
Period 11 | 2011-02-04 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 12 |  | 197 | 310
Period 11 | 2011-02-05 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 6 |  | 197 | 310
Period 11 | 2011-02-06 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 12 |  | 197 | 310
Period 11 | 2011-02-13 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 6 |  | 197 | 310
Period 11 | 2011-02-14 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 12 |  | 197 | 310
Period 11 | 2011-02-24 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 14 |  | 197 | 310
Period 11 | 2011-02-24 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 12 |  | 197 | 310
Period 11 | 2011-01-29 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 30 |  | 70 | 427
Period 11 | 2011-02-13 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 20 |  | 70 | 427
Period 11 | 2011-02-15 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 20 |  | 70 | 427
Period 11 | 2011-02-20 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 10 |  | 70 | 427
Period 11 | 2011-02-08 00:00:00 | 005 | 25 Watt SES Clear Oven Lamp |  | 200 | 401 | -11