J
joneill
Is there a way to keep the references in a formula constant when the cells they point to are moved
For example
On Sheet 1, cell A1 contains the number 50. On Sheet 2, cell A1 contains the formula "=Sheet1!$A$1"
If I move the 50 on Sheet 1 to cell B1 (cut-and-paste), the formula on Sheet 2 changes to "=Sheet1!$B$1"
Can I force the formula to point to Sheet1!$A$1 even when I move that cell's contents
Thanks
~J
For example
On Sheet 1, cell A1 contains the number 50. On Sheet 2, cell A1 contains the formula "=Sheet1!$A$1"
If I move the 50 on Sheet 1 to cell B1 (cut-and-paste), the formula on Sheet 2 changes to "=Sheet1!$B$1"
Can I force the formula to point to Sheet1!$A$1 even when I move that cell's contents
Thanks
~J