Hi,
Im new in using macro.
So I got a sheet that contain information about master budget in finance. In example I got the A column for account number, B column for account name, C for Department name, D, E, F, G is user input manually, H is inflation value (that is constant), and I is total (let say it if the cell is I3 so the formula would be = D3+E3+F3+G3).
The data is start from the 7th row tho the 52th row.
What can I do if I want to protect thee sheet (to protect the formula in column I), but when I insert a row (bc sometimes user need to insert new row when the data is too many), it will be :
1. Copy value inflation in column H above the row
2. Copy formula from column I above the row
I would be really thankfull if somebody help me on this matter
Bookmarks