Split the total rows for every 250

[nianchi111]

Hi,

I have an excel file with data in Column A and B.

On an average it will be somwhere 3000 line items.

I need to find the first 250 line items and insert a row below and Add up the Column B and repeat the same process of splitting 250 till the end of line items.

Challenge is that in Column A we will be having the same numbers. for example

Example A

S.No Column A Column B
245 123456 25
246 123456 35
247 123456 45
248 123456 55
249 123344 25
250 123344 250
251 122445 77
252 122445 54
253 122445 26
254 122445 11

In this example its clear that we need to insert a row below the S.no 250 and add the value of column B.


Example B

S.No Column A Column B
245 1122553 25
246 1122553 35
247 123456 45
248 123456 55
249 123456 25
250 123456 250
251 123456 77
252 123456 54
253 122445 26
254 122445 11

If you see the s.no 250 its has the similar number in the below cells so we need to insert a row at 246 since it does not have the same number in the below cell.

Hope anyone helps me with this.... thanks in advance....
Thanks,
Vimal Vikraman