I could not desipher, what you exactly wanted, so I made 2 possible solutions. On sheet Shedule, columns for Rep1 take loads sent actually out as base, and are matching them with scheduled loads. Colums for Rep2 take scheduled loads as base, and are matching them with actual loads.

In either of reports, something is left out. To get a report, where all scheduled loads and all actual loads are displayed, and positioned to match, can't be made in same table, and is much more complex to create.

Btw, in my solution the actual position of loads in table is moot - the load numbers are calculated based on scheduled/actual time.

Attached Files

example2.xlsx (23.2 KB, 17 views)