I have an add row button that adds a new table row and updates the formula.
The formula in one of the cells is =IF(B8 = "", "", B8 - B3-B3+C3+C3-D3)
When I add a row using the button it autofills the formula and changes it to =IF(B9 = "", "", B9 - B4-B4+C4+C4-D4)
I want the B column to update but I need C3+C3-D3 to stay the same.
This is a template sheet for calculating rails and styles of cabinet doors , C3 and D3 is user input that will change from sheet to sheet based on the width of the frame.
Is this possible?
The formula in one of the cells is =IF(B8 = "", "", B8 - B3-B3+C3+C3-D3)
When I add a row using the button it autofills the formula and changes it to =IF(B9 = "", "", B9 - B4-B4+C4+C4-D4)
I want the B column to update but I need C3+C3-D3 to stay the same.
This is a template sheet for calculating rails and styles of cabinet doors , C3 and D3 is user input that will change from sheet to sheet based on the width of the frame.
Is this possible?