Macro to sum up range and anything above certai value move to next row in group

[audiorij]

I need help with a macro to look at a range of BINS with Quantities in them. Match those quantities to a shipment value (starting from the left to right) and anything above the shipment value move to the next row in the same Object group It should keep doing this for each group until the last ROW is met. See images;

This is before;

EXCEL-VBA.jpg

This is after;

EXCEL-VBA-2.jpg

ROW is the iteration of the object and represents shipment 1, 2, 3 and 4. 1st shipment of Apples needs 200 from the BINS starting with BIN1 and going to the end. Everything else should go to shipment (ROW 2) until that Shipment quota is met and then everything else go to (ROW 3) etc.

Any help is greatly appreciated.

[audiorij]

Is there a way to do this? have written a few macros but not sure how to solve this one, adding up the individual column values to compare to the shipment needed value and doing the math from there.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[audiorij]

Hmmm I ran that macro on the page with my testing data and it didn't do anything..... oh wait you were just summing up each row?

No I can do that. What I need is a macro that does the math in my original post. Basically for each "Object" there can be several shipments each one indicated by "ROW" number. I would like a macro or something that would compare the BINS starting with 1 and going to 5 with the "Needed For Shipment" number. When that number is reached the remaining values in the row of BINS would drop down to the next ROW (2) and then match those numbers in the same way with the 'Shipment Needed" for that ROW and do the same thing until all the values in the BINS are used up.