ExcelBanter - insert blank row and formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - insert blank row and formulas (https://www.excelbanter.com/excel-worksheet-functions/263174-insert-blank-row-formulas.html)

insert blank row and formulas

when I insert a new row in my worksheet, I noticed it does not update the
formulas for any row below that line that reference another sheet in my
spreadsheet. For example, if my formula references 'sheet2'!I14 and I insert
a row above that formula it does not change the formula to 'sheet2'!I15. Is
there a way to have it where it does update the formula properly just like it
would do if I referenced a cell on the current sheet I was working on?

insert blank row and formulas

Why would the formula need to change? You're moving the output destination,
not the input location.

--
Best Regards,

Luke M
"scottmcm" wrote in message
...
when I insert a new row in my worksheet, I noticed it does not update the
formulas for any row below that line that reference another sheet in my
spreadsheet. For example, if my formula references 'sheet2'!I14 and I
insert
a row above that formula it does not change the formula to 'sheet2'!I15.
Is
there a way to have it where it does update the formula properly just like
it
would do if I referenced a cell on the current sheet I was working on?