Hi,

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

Befo
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!

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


€žlloydyleg11€� ezt Ã*rta:

Hi,

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

Befo
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!