How to automatically allocate stock to pallet with a limit space

Hello,

I have been going through threads to try a work out a formula to allocate stock on my sheet.

Whenever we have information in Stock list B17:D23, it will automatically distribute to releated pallet type.
There are 6 types of pallet B2:D9. Attached file for your information, I have attached the sheet with minimal data.

If anyone has done anything similar, or has an idea on how to do any of this, any help is much appreciated.

I don't know if this will help ....


https://www.excelforum.com/excel-gen...alculator.html