Sort the range of values based on the maximum sum or limit value

[Amar313]

Dear people,

I have a question, hope you can help me. My question relates to sorting the production order based on its daily production capacity.

As you can see in production column, i want to make a condition where If the production exceeds the maximum daily production capacity available in a day, allocate the portion of the production that does not fit into Day 1 into Day 2. I set the daily production capacity = 1200 pcs/day. Therefore the output result should look like the production order where the total production (pcs) in a day should not equal more than daily production capacity.

I prefer VBA code, but if otherwise possible than I hope you can help me.

I would really appreciate any guidance or even a start! Let me know if i should provide any further clarity.

 

[Amar313]

maybe it looks like the answer in this link below
Calculate combinations that leads to max intake in VBA using one column

but the result only changes the order in the row table