Shipping Optimization Tool

Hi everyone,

This is less so much of an issue with some code, but seeking some guidance to how best tackle a problem.

I am attempting to create a userform which takes product information (I sell flat steel plates) and generates an optimised load to ship to customers overseas. Currently this is done by hand and I believe can be improved upon. The problem is that I would like a form which essentially can look at possible ways to organise the products and select the cheapest way to organise the shipping containers. I am struggling to code in the logic that would determine which container to select to fill, that is, how can I code the program to look at what products are still to be loaded, and choose the best combination of shipping containers to accommodate them.

I apologise if this seems as though I asking for someone to make the program for me, but I am unsure as to how to solve this issue, I have had many attempts and each time I find some way in which the program cannot perform.

I have attached the program I currently have as well as an example of the kind of products that require shipping at one time, and how this would be organised. Any guidance is greatly appreciated.

Please let me know if I can provide anymore information, as I am having trouble explaining my situation.