![]() |
#2
|
|||
|
|||
![]()
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. |
Tags |
cross referencing, formula help, index match |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cross reference data from 2 different worksheets | connell.richard@gmail.com | Excel | 0 | 12-06-2016 04:26 AM |
Cross-reference / lookup data from one tab and display on another - How to | lonniepoet | Excel | 0 | 02-24-2016 01:31 PM |
![]() |
ekeithjohnson | Excel Programming | 3 | 08-23-2014 11:26 PM |
![]() |
wmac | Word | 1 | 05-14-2013 08:54 PM |
![]() |
Santa_Clause | Word | 2 | 02-02-2010 04:37 AM |