Hello there,

I have these “Load Lists” that we list out products, that includes Description, Quantity, and Size, we print these out and give them to the driver so they know what they are going to deliver. My goal is for each listed item in the Load List (word doc) to connect with the correct corresponding description and size from the excel sheet, so that when a load list is finished, the quantity that we ship out will be deducted from the excel sheet and keeps inventory counts up to date.

The goal would be keeping the load list “blank” or hide all functions, so it just prints out the amounts for what they need for the shipment.

As a bonus maybe I can have a running list of links to each load list for the respective Items that we sed out, it seems possible to me. 

I have tried doing vlookups and special formatting pastes, nothing seems to work out how i want it. 

Can someone please help me out with this?

​Hello there, I have these “Load Lists” that we list out products, that includes Description, Quantity, and Size, we print these out and give them to the driver so they know what they are going to deliver. My goal is for each listed item in the Load List (word doc) to connect with the correct corresponding description and size from the excel sheet, so that when a load list is finished, the quantity that we ship out will be deducted from the excel sheet and keeps inventory counts up to date. The goal would be keeping the load list “blank” or hide all functions, so it just prints out the amounts for what they need for the shipment.As a bonus maybe I can have a running list of links to each load list for the respective Items that we sed out, it seems possible to me. I have tried doing vlookups and special formatting pastes, nothing seems to work out how i want it. Can someone please help me out with this?  Read More

​