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

Can anyone point me in the right direction macro etc

Thanks in advance

Pk24

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

Can anyone point me in the right direction macro etc

Thanks in advance

Pk24

Last edited: