Jan 09 2021 08:47 AM
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 new data, the formula will know to go to M523 for the recalculation.
Jan 09 2021 10:12 AM
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
Jan 09 2021 01:20 PM
If you copy your formula, the cell references will change automatically.
so, if wrote your formula in L522 =SUM(M522+H525)-G525 and you copy the formula to L523, they formula will be =SUM(M523+H526)-G526, this is called absolute references in excel
Jan 09 2021 03:43 PM
Looking for a way for the cell shown highlighted to drop down to the next cell, $534, when I enter that data.
Jan 10 2021 01:08 PM
@Gizmo2255 The image doesn't provide much help on my end. If you can, attach the workbook or just a sheet that replicates the formulas you have to make it easier to understand