lloop to fill different cells regarding an Data base

Hello to every one,

It seams that I need an loop vba to (from my attachment the red side) split in different boxes the content of one series.
it has to work like this:

-on the yellow side on the column "A" I write the series number who exist in Data base, one by one in different time of the day as you can see in column "B". The VBA code hast to see all the time when I fill the last cell in column "A"
-the yellow side comes filled automaticaly by an vba code.
-the specific series content is made all the time from different parts name from '340 to '410.
-this parts I have to split them in boxes.
-the number of total boxes is all the time different an depending by the total number of parts from the series ( calculated in column "L"). It can be that, as an example, I have one series and the content is made of 10 pieces/3=3.3 => 4 boxes,but in this case I can put in the last box 4 pieces, so my distribution it will be Box X: 3 pieces; Box Y: 3 pieces; Box Z: 4 pieces.



IF anybody can have an look to this problem it would be very helpful for me.

Best Regards.

P.S. if you need some more info please feel free to ask.