updating formula
the previous code really helps me in inserting new row under the selected row (along with its formulas too).. Great! But now i'm facing a problem where the SUM formula is not updated after adding the new row.. For example:
Lisa 10
Jack 20
Sarah 10
Willy 5
Total 45
adding a new row (Mark) after Willy..
Lisa 10
Jack 20
Sarah 10
Willy 5
Mark 5
Total 45
but, as we can see the Total is not updated.. it should be 50, not 45.. anyway, is there any need of inserting macro in the TOTAL cell or using certain formula (summation)? hope experts get what i mean here..
for the current, i'm using my own method to update the formula automatically:
adding new row (Mark) between Sarah & Willy..
Lisa 10
Jack 20
Sarah 10
Mark 5
Willy 5
Total 50
now the total is 50.. i wish i wouldn't want to use this method.. hope any experts can solve my problem here.. thanx~