Communication between 3 sheets
Hello and Help...
Were are trying to do the following and I just can't wrap my head around it.
There are 3 sheets that we'd like to communicate with one another.
- Truckload Inventory Log - A virtual parking lot of where loads are being held
- Receiving Log - A chronological log of loads received
- Shipping Log - A chronological log of loads sent out.
Basically, we'd like the shipping log to communicate with the Truckload Inventory Log to show where the load is at. A "slot" column would communicate with the T.I.L and pull the BOL number into it.
Once the load is sent out then the Shipping log would communicate with the T.I.L. and remove it from the log.
Is this possible ?
Help Article Resources
Check out the Formula Handbook template!