Monitor cell value and copy it to another cell

Question

I would like to know how to monitor a cell value and make this value always updating on some other cell.

Until now i was using the = sign and then choosing the cell i want to monitor.

The problem is that the row/cell i'm monitoring is constantly updating due to another vba script, and when that happens i get REF error.

e.g.

On the M8 cell (sheet1) i have this simple formula to monitor the value in the summary sheet on the A3 cell:

=summary!A3 (works fine displaying the cell value)

But after the rows are deleted OR updated..i get this behaviour on the M8 cell in the sheet1.

=summary!#REF!

Does anyone know how can i lock the formula so it never changes?

Thanks

Answer 1

Try =INDIRECT("summary!A3") - this will ALWAYS refer to A3 regardless of any Sheet changes.