insert row when sum of values equals 100

[lloydyleg11]

Hi,

I would like to insert a blank row when the sum of the values in a column of
cells equals 100.

Before:
1
2 10
3 90
4
5
6 50
7 50
8
9 10
10 10
11 80
12

After:
1
2 10
3 90

4
5
6 50
7 50

8
9 10
10 10
11 80

12

Hope this makes sense!

The values in the second column will always add to 100...

Thanks in advance!

 

[Stefi]

Are there always blank cells below series of values, in your example cells
4,8,12?
Stefi


„lloydyleg11†ezt írta:

 

[lloydylegs11]

hi Stefi,

im not sure if i understand your question... the first column i entered was the row numbers. the second the values in the cells. there are not always blanks after the sum equals 100, sometimes the values keep going.

the after case what i would like it to look like after running a macro or something. the blanks in the row numbers are the places i would like to insert rows, after the sum of 100 is reached.

hope this clears it up??

thanks