Hi
Working EXCEL 2010
I working in Excel 2010 and have a column that I have a formula in. Everytime I add a new row the formula's in all the columns update to the new Row automatically. (that's Great )
Now in one of the columns , I need to change the formula but I want to keep the old formula for the old data / calculations. So from row 4813 onwards I want the new formula to start. So basically need to keep the old formula for the past calculation , but have the new formula for the new info.
The problem is as I add the new formula the update / auto fill icon appeared and wanted to update the entire column. I did not allow it to .
However, everytime after the new formula I add a row , it updated the column with the old formula and not the new on. So I have to go and copy the new formula over the old one each time
I would like to keep my formulas to move down automatically when i add a new row into the Table.
Hope you understand my proble.
Thanks
Vaughan
Working EXCEL 2010
I working in Excel 2010 and have a column that I have a formula in. Everytime I add a new row the formula's in all the columns update to the new Row automatically. (that's Great )
Now in one of the columns , I need to change the formula but I want to keep the old formula for the old data / calculations. So from row 4813 onwards I want the new formula to start. So basically need to keep the old formula for the past calculation , but have the new formula for the new info.
The problem is as I add the new formula the update / auto fill icon appeared and wanted to update the entire column. I did not allow it to .
However, everytime after the new formula I add a row , it updated the column with the old formula and not the new on. So I have to go and copy the new formula over the old one each time
I would like to keep my formulas to move down automatically when i add a new row into the Table.
Hope you understand my proble.
Thanks
Vaughan
