View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default insert row when sum of values equals 100

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!