Excel reference a cell?
Can I reference a cell (A1) in another worksheet and then if that row gets deleted i want the cell to continue to reference what is the new value in A1. does that make sense? I want a cell to always reference the value is cell A1 even if it gets changed by being deleted.
More Questions From This User See All
Answers & Comments
Verified answer
You need to put the calle name in text and use it in the formula through the indirect function.
For example, in cell A1 of Sheet2 you can reference cell A1 in Sheet1 with this formula:
=INDIRECT("sheet1!A1",TRUE)
If you delete the first row in Sheet1 then in sheet2 will show the contents of the new A1 cell
use $A$1