Forum Discussion
Gizmo2255
Jan 09, 2021Copper Contributor
Formula automatically adjusts to grab the next cell below
How do I program a formula to grab the next cell below so that it automatically includes that cell in the formula recalculation. Ex) =SUM(M522+H525)-G525 Where when I insert a new row below with ne...
adversi
Jan 09, 2021Iron Contributor
Can you provide some more information on the formula adjustment? Sharing a sample workbook, without any sensitive data, of what the current formula generates and what the adjusted solution should be will help
Gizmo2255
Jan 09, 2021Copper Contributor
Looking for a way for the cell shown highlighted to drop down to the next cell, $534, when I enter that data.