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

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?

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?

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

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?