A
Andrew
I have a formula on Sheet2 that refers to a cell on Sheet1. As a simple
example, cell A12 on Sheet2 contains the formula:
=Sheet1!A12
I want this formula to always refer to cell A12 on Sheet1, irrespective of
any changes that are made to Sheet1. At the moment, if a row is inserted
above row 12 on Sheet1, then the formula is automatically adjusted to:
=Sheet1!A13
I do not want this behavoiur; I want it to continue refering to cell A12.
Is this possible? Using an absolute reference ($A$12) makes no difference.
example, cell A12 on Sheet2 contains the formula:
=Sheet1!A12
I want this formula to always refer to cell A12 on Sheet1, irrespective of
any changes that are made to Sheet1. At the moment, if a row is inserted
above row 12 on Sheet1, then the formula is automatically adjusted to:
=Sheet1!A13
I do not want this behavoiur; I want it to continue refering to cell A12.
Is this possible? Using an absolute reference ($A$12) makes no difference.