Multiple Truck Load Builder

HELP!

I've built a tool that automatically creates the pallets/load units based on cases of product ordered. However, I'd like to find a way for this excel tool to build out the truck loads.

In the example, the max load units per truck are 30, I need the tool to build out the needed truck loads. For example; truck load 1 would show item# and total load units (up to 30 units), without duplicating items in a truck.

Hopefully that makes sense.