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

S

stbookkeeper

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

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
 
Top