I'm trying to build a spreadsheet to track my finances better. I tried to make it as dynamic and user friendly as possible so that others in my family can use it as well (they're not Excel savvy).
Since I wanted the areas and categories of tracking to be dynamic, I used tables, which pulls from other tables in other sheets (1 sheet per month, 3 tables per month for different areas of personal finance).
The problem I'm running into is when I insert a new row into the tables, some tables won't copy the formulas correctly from the row above and some tables will. Some new rows will reference the cell in the bottom left corner of the table, while others will copy just fine.
Entertainment1 shows the new row behaving correctly and moving the formulas down as it should
Housing2 and Savings1 show the new row pulling formulas from incorrect locations