ExcelBanter - How can a formula in a cell automatically update when inserting a.

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

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

- - How can a formula in a cell automatically update when inserting a. (https://www.excelbanter.com/excel-worksheet-functions/32186-how-can-formula-cell-automatically-update-when-inserting.html)

stbookkeeper

How can a formula in a cell automatically update when inserting a.

Is there a way to format a cell so that the formula connected to that cell
automatically adjusts to a line insertion?

Peo Sjoblom

No, you can put a reference within indirect and it always will point to that
particular cell

=INDIRECT("A2")

as opposed to =A2

Don't know if that's your problem though

Regards,

Peo Sjoblom

"stbookkeeper" wrote:

Is there a way to format a cell so that the formula connected to that cell
automatically adjusts to a line insertion?

All times are GMT +1. The time now is 02:20 AM.