L
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
*inserted blank row*
4
5
6 50
7 50
*inserted blank row*
8
9 10
10 10
11 80
*inserted blank row*
12
Hope this makes sense!
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. The values in the second column
will always add to 100...
Thanks in advance!
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
*inserted blank row*
4
5
6 50
7 50
*inserted blank row*
8
9 10
10 10
11 80
*inserted blank row*
12
Hope this makes sense!
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. The values in the second column
will always add to 100...
Thanks in advance!