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

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!