I have a macro that adds a new row to the bottom of a list of tasks. Above the list is a formula that adds one of the columns. It's a simple SUM formula for the numbers in the rows below it.
When I add the new row at the bottom, the formula does not adjust to include the newly added row the way it would if the row was inserted in the middle of the list.
Can someone help me adjust the formula in the top right cell automatically after the row is inserted?
When I add the new row at the bottom, the formula does not adjust to include the newly added row the way it would if the row was inserted in the middle of the list.
Can someone help me adjust the formula in the top right cell automatically after the row is inserted?
| Construction Project Schedule Template.xlsm | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | E | F | G | H | |||||
| 53 | 8 | Task Group Title | 2/17/2021 | 2/21/2021 | ||||||
| 54 | 8.01 | Task 1 | 7.05 | 2/17/2021 | 2/17/2021 | |||||
| 55 | 8.02 | Task 2 | 8.01 | 2/18/2021 | 2/18/2021 | |||||
| 56 | 8.03 | Task 3 | 8.02 | 2/19/2021 | 2/19/2021 | |||||
| 57 | 8.04 | Task 4 | 8.03 | 2/20/2021 | 2/20/2021 | |||||
| 58 | 8.05 | Task 5 | 8.04 | 2/21/2021 | 2/21/2021 | |||||
| 59 | 8.06 | |||||||||
Project Programme | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F53 | F53 | =IF(ISBLANK(F54),0,MIN(IF(F54:F58<>0,F54:F58))) |
| G53 | G53 | =IF(ISBLANK(G54),0,MAX(IF(G54:G58<>0,G54:G58))) |
| H53 | H53 | =SUM(H54:H58) |
| F54:F59 | F54 | =IF(ISBLANK(E54),0,IF(E54="None",$F$10,VLOOKUP(E54,$A$10:$G$71,7,FALSE)+1)) |
| G54:G59 | G54 | =IF(ISBLANK(E54),0,IF(H54=0,F54,IF(D54="Mon-Fri Only",WORKDAY(F54,H54-1,0),F54+H54-1))) |
| A54:A59 | A54 | =ROUND(A53+0.01,2) |
