Splitting Orders to Reduce Average Weight? Division of Weight and Allocating QTY

[razzandy]

Hi Guys

So, occasionally I need to split an order into two or more to reduce and average weight and I have some VBA code which simply divides the Total Weight by the amount I want to divide the order into. So for instance I have an order with a weight of 6480g and the quantity purchased is 5. If I wanted to split this order into 3 my system simply divides 6480 by 3 but the problem is the packed items would be 2, 2 and a 1 so I need a way to first calculate the QTYs per order then recalculate the weight. If I simply divide the weight by the split amount l would have to split a product into 1.6 recurring (Not Possible, Customer wants a full product))! So I am TRYING, 'very TRYING', to come up with either a formula or (preferred VBA) to come up with logic which will work out what the QTYs divided by 3 would be 2, 2 and 1 at this point I can then easily recalculate the weight per order line. Hope this makes sense?

Here is a screenshot before the split:

Here is a Screenshot after I have split an order in 3:

Thanks in advance guys

 

[razzandy]

Sorry Guys I missed the below!

I want the end result to look like this: