监视单元格值并将其复制到另一个单元格 [英] Monitor cell value and copy it to another cell

问题描述

我想知道如何监视一个单元格的值，并使这个值总是在其他单元格上更新。

直到现在我使用=选择要监视的单元格。

问题是，我正在监视的行/单元格是由于另一个vba脚本而不断更新，而当我发生这种情况时 REF 错误。

例如

code> M8 cell（sheet1）我有这个简单的公式来监视 A3 单元格的摘要表中的值： p>

= summary！A3 （正常显示单元格值）

但是在行被删除或更新后，请在sheet1中的 M8 单元格上获取此行为。

有没有人知道如何锁定公式，使其永远不会改变

谢谢

解决方案

尝试 = INDIRECT（ 总结！A3） - 这将永远是指A3，而不管任何Sheet更改。

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

解决方案

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

这篇关于监视单元格值并将其复制到另一个单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！