Hi Everyone,
I need to Split the Excel into multiple CSV files based on the Sum of column values in the Excel. For Eg.

I have 2 columns in the master Sheet:

ID Rate
401049500 1
403777395 1
401526003 9
403502518 2
1419049 4
409637116 1
402594533 6
402594505 1
402594536 8
2291489 1
1321108 1
402636625 9
404531848 1
2758290 1
1107616 9
411015029 1
647360 1
2231088 1
401156929 3

The ID column should be splitted based on the sum of the Rate column i.e with sum of 10.