Multiple Truck Load Builder

Is there also a requirement to minimise the number of trucks? i.e have as close to 30 units in each truck as possible. If so this will need the Excel Solver

If not the attached may be what you want. If so it just needs a one line macro to filter the Load units >0 from the Order sheet to the Filtered Loads sheet.
In which case just let me know.

Solver would aim to get as close to 30 as possible but there may not be any combinations that total exactly 30 meaning there will always be some space whilst minimising the number of trucks

Just tried a solver solution but with a matrix of 47 products and a minimum of 5 trucks with the 134 load units that puts the number of variables over Solvers limit, which seems to be about 200.

The last solution is a pragmatic one and it may be possible to refine it for other mixtures of loads. As it stands though it shows the minimum number with unused load space of 10, 4 & 6 for trucks 2,4 & 5

In extremis if all your loads were 16, i.e. over half of the permitted 30, then you would need 47 trucks. Practically this would be unlikely but the number of trucks required will be somewhere between the absolute minimum, 5 in this example, and the number of loads.

One refinement would perhaps be to sort the list in ascending order and then take the running total up to 30 for the first truck, then start the running total at the next load ...etc.

Are there any other factors that could be used to refine the selection process.

Variables needed to calculate the loading calculator is Truck Capacity and Requested Amount
let say:
requested amount is in A1
truck capacity is in B1

to get amount of full loaded truck

Formula:

=FLOOR(A1/B1 ; 1)

to get total truck needed

Formula:

=CEILING(A1/B1 ; 1)

to get amount of leftover to load to the last truck

Formula:

=MOD(A1 ; B1)

(I have attached the .xlsx as example)

How does #7 relate to the OP's requirement?