Hi:
Hope someone will be able to help with this. One of my formulas references a cell from another worksheet as part of its calculation. However, this cell being referenced does move around because various sorts are being performed, resulting in incorrect values. Is there a way to reference a cell regardless of whether it moves or not?
e.g. formula
='sheet2'!I38*C8/60
The cell I38 in sheet2 is liable to move.
Thanks
Hope someone will be able to help with this. One of my formulas references a cell from another worksheet as part of its calculation. However, this cell being referenced does move around because various sorts are being performed, resulting in incorrect values. Is there a way to reference a cell regardless of whether it moves or not?
e.g. formula
='sheet2'!I38*C8/60
The cell I38 in sheet2 is liable to move.
Thanks