Splitting a Sheet into many at a sum/value in a column

[scarii]

Hi,

I process large billing files and have a limitation of loading into our account systems with a value of $50k.

With my sheet having a column total of $430k, I want to use a macro to split my sheet when a certain column sums $50l or less (as close to $50k as possible.)

Does anyone have any info on how to do this?

I currently use a VB Macro to split the sheet based on over 800 rows, but I then have to go through and manually edit it and moves rows when those 800 lines go over 50k.

Example.xlsx

I have attached a small sample of my Sheet.

Thanks

[JapanDave]

Try this, Add some data to the bottom of the sheet and see if it does what you are after?

[scarii]

Thanks That sort of worked.

the count/sum total went just over $50k, so might have t change that to $49 to allow some spill over to remain under $50k.

Only thing was that is split the first lot, but nothing after.... my spreadsheets are over 5000 lines so I need to split all of those into seperate sheets with under $50k worth of values...