Home

Excel Table New Row Formula Problems

%3CLINGO-SUB%20id%3D%22lingo-sub-371511%22%20slang%3D%22en-US%22%3EExcel%20Table%20New%20Row%20Formula%20Problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-371511%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20build%20a%20spreadsheet%20to%20track%20my%20finances%20better.%20I%20tried%20to%20make%20it%20as%20dynamic%20and%20user%20friendly%20as%20possible%20so%20that%20others%20in%20my%20family%20can%20use%20it%20as%20well%20(they're%20not%20Excel%20savvy).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20I%20wanted%20the%20areas%20and%20categories%20of%20tracking%20to%20be%20dynamic%2C%20I%20used%20tables%2C%20which%20pulls%20from%20other%20tables%20in%20other%20sheets%20(1%20sheet%20per%20month%2C%203%20tables%20per%20month%20for%20different%20areas%20of%20personal%20finance).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20I'm%20running%20into%20is%20when%20I%20insert%20a%20new%20row%20into%20the%20tables%2C%20some%20tables%20won't%20copy%20the%20formulas%20correctly%20from%20the%20row%20above%20and%20some%20tables%20will.%20Some%20new%20rows%20will%20reference%20the%20cell%20in%20the%20bottom%20left%20corner%20of%20the%20table%2C%20while%20others%20will%20copy%20just%20fine.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEntertainment1%20shows%20the%20new%20row%20behaving%20correctly%20and%20moving%20the%20formulas%20down%20as%20it%20should%3C%2FP%3E%3CP%3EHousing2%20and%20Savings1%20show%20the%20new%20row%20pulling%20formulas%20from%20incorrect%20locations%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-371511%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETables%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
ExcelNoob23
Occasional Visitor

Hello everyone,

 

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies