Spreadsheet help

Hi,

I need some ideas and help. We have a spreadsheet that has two sections (green for fresh and blue for frozen). We enter all fresh deliveries on green section and frozen deliveries on blue section. We cannot mix fresh/frozen deliveries but sometimes we break this rule. We plan runs every day. For example, I will have 2 deliveries for Richmond Hill at 8 and then 1 for Scarborough and one for Markham, I will put them all together and put the driver name beside them (or truck # 1 if I don't know who the driver will be yet). Dock then looks at the plan, sees all the deliveries for each driver and loads it in that order.

Problem is, we want to divide the delliveries by areas. We want to separate by frozen West, fresh West, frozen East, fresh East, frozen downtown, fresh downtown etc etc. This is so we can look at the spreadsheet on any given day and tell at a glance how many Toronto deliveries we had vs how many Mississauga deliveries. Sometimes one driver may have deliveries for multiple areas and he may be driving from West end to East end or vice versa. We don't want to confuse the dock by keeping deliveries in separate areas on the spreadsheet and putting driver names besides deliveries because dock personnel aren't the most detail oriented and may miss some deliveries if they are not grouped together.

Are you guys able to give ideas of how to format the spreadsheet so we can keep deliveries for each driver grouped together yet keep them separated by areas?

I have attached two examples to make it easier to understand. First is with drivers/deliveries grouped together and second is with separated areas.

TIA.new.jpgold.jpg