Advanced Logical Linking Formulas in Excel

lonnykoons 

It looks like a big complicated project, however the reason why you're lost trying to make sure the proper data is displayed is because you don't have any.

Where is the loads data?

When I say where the load data is, I mean the raw data.

For example:

You get a load, what are it's attributes?

Load Number

Origin

Destination

Date received

Target delivery date

Target pick up date

Miles

Drop and Hook?

Live load?

Live unload?

Lumpers?

etc. etc.

Where are the load details because these are the data that you are lost trying to display because you don't have any.

Create the Loads table first.

Start there, then you can figure out what other how to move the data in the load table into another table that you will create follow the manual procedure first before you can automate the process to make it efficient.  Stop focusing on formatting and beautiful it is going to look and focus instead on gathering the data and the process logic.

You already know the process, and possibly the load data the very thing that you are going to play with the system that you are trying to build.