Automatic carton and pallet numbering [closed]

I have a spreadsheet with fill-in quantities ordered for each item in column D, and box numbers and pallet numbers automatically in columns I and K. Please help with this

If I divide 33 by 30, the answer, as most would say, would be 1.1 to an infinite number of decimal places. The process of packing the remaining three units, cartons, and pallets is also automatically mentioned and combined with the following items until 30 units are loaded.Also, this question.enter link description here