Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 *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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert row when sum of values equals 100 | Excel Discussion (Misc queries) | |||
Insert new ROW if cell equals value | Excel Worksheet Functions | |||
Insert rows (1 to 4) if the cell value equals a fixed word | Excel Discussion (Misc queries) | |||
custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Can I change the Insert Function button to an equals sign? | Excel Discussion (Misc queries) |