Splitting column of numbers into multiple columns moving to new column based on value

Hi


I have a spreadsheet with store numbers in column A , and units in column B


I need to split this into batches of new columns adding up the units in B and moving to new column when value is equal or greater than


Eg

A. B

601 1
602. 2
603. 3
604 4
605. 5
606. 1
607. 3



If I set value to check for as 4. Would become (ignore dots)

C. ...D. ..E. .F. ..G. .H. I. ..J

601. 1. 604. 4. 605. 5. 606. 1
602. 2. ......................607. 3
603. 3


I have managed to do this with following macro

Please Login or Register  to view this content.

But know I need to do a second check


I need when it splits to check the total of the previous units if above a certain qty to move the last data to next column , if equal or below to duplicate last data on bottom of current column to top of next column unless it is last data

Ie. if original check was 4 I'd get these results

C. ...D. ..E. .F. ..G. .H. I. ..J

601. 1. 604. 4. 605. 5. 606. 1
602. 2. ......................607. 3
603. 3

But after a second check on the total of previous data for 3
Would return

C. ...D. ..E. .F. ..G. .H. I. ..J. K. L

601. 1. 603. 3. 604. 4. 605. 5. 606. 1
602. 2. 604. 4...................... .607. 3
603. 3


Hope this makes sense


Thanks in advance



Pk24