Hello All,

I am looking for some VBA that will help me to make transportation planning. The range B9:E11 is defining the size of trucks in CFT and range B12:E14 is defining the loading capacity of those vehicles in CFT. My objective is ensuring the maximum capacity utilization (%) that will be reflected on cell E19 along with the rounded number of trucks required in range E15:E17. Here the input or required load CFT is reflected on cell E8. I hope that a VBA can ensure the optimization of the overall process as I failed applying some formulas.

Could you please check the attached file and help me to sort out the problem?

Thanks in advance for your time and cooperation.

Regards

Shazzad