Spreadsheet: 218197d1362395981-if-same-column-in-multiple-sheets-is-marked-with-an-x-how-can-i-extract-surrounding-data-upload-data
Sheet: Week 5

 |  |  |  |  | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Bridgewater | Thrapston | Bradford | Gadbrook | [NAME] | [NAME] | Motherwell
 |  |  |  | No. In Box | 18 | 12 | 6 | 18 | 12 | 4 | 4 | 216 | 162 |  |  |  |  |  |  |  |  |  | Cost of Transport | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  | No. On [NAME] | 40 | 50 | 50 | 40 | 50 | 30 | 40 | 2.5 | 2.5 |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Space on [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cost
 | Sunday
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets | Opp | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater |  | 2013-02-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Transport Sheet
 | Thrapston |  | 2013-02-24 00:00:00
 | Bradford |  | 2013-02-24 00:00:00
 | Gadbrook |  | 2013-02-24 00:00:00
 | [NAME] |  | 2013-02-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Despatch Sheet
 | [NAME] |  | 2013-02-24 00:00:00
 | Total Boxes
 | Motherwell |  |  | 5--2
 | Total Boxes
 | Monday
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Transport Sheet
 | Thrapston
 | Bradford
 | Gadbrook
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Despatch Sheet
 | [NAME]
 | Total Boxes
 | Motherwell |  |  | 5--3
 | Total Boxes
 | Tuesday
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Transport Sheet
 | Thrapston
 | Bradford
 | Gadbrook
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Despatch Sheet
 | [NAME]
 | Total Boxes
 | Motherwell |  |  | 5--4
 | Total Boxes
 | Wed
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Transport Sheet
 | Thrapston
 | Bradford
 | Gadbrook
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Despatch Sheet
 | [NAME]
 | Total Boxes
 | Motherwell |  |  | 5--5
 | Total Boxes
 | Thurs
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Transport Sheet
 | Thrapston
 | Bradford
 | Gadbrook
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Despatch Sheet
 | [NAME]
 | Total Boxes
 | Motherwell |  |  | 5--6
 | Total Boxes
 | Friday
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Transport Sheet
 | Thrapston
 | Bradford
 | Gadbrook
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Despatch Sheet
 | [NAME]
 | Total Boxes
 | Motherwell |  |  | 5--7
 | Total Boxes
 | Sat
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Transport Sheet
 | Thrapston
 | Bradford
 | Gadbrook
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Despatch Sheet
 | [NAME]
 | Total Boxes
 | Motherwell |  |  | 6--1
 | Total Boxes