I'm trying to set up a budget workbook for my personal budget using 13 sheets, 1 for the totals and the other 12 for each month. I cannot for the life of me figure out why the formulas I have change when I insert a row into one of the monthly sheets. Here's an example of one of the formulas I have:
If I insert a row at the top of a sheet, it will increment the twos to threes, throwing off the calculations. Is there any way I can lock the formula from changing at all? It's incredibly frustrating.