Hello world,
I have a bunch of cells that just show the values of cells in other Sheets in the workbook. However, the cells whose value is shown get cut and pasted a lot. Excel automatically follows the cells that are referenced rather than giving me the new data in the cells it is set to refer to. Let me give an example:
Excel1.PNG
Here the formula in cell B1 correctly displays the text "Test" from cell A1. However if I cut and paste A1 into B1, the formula changes:
Excel2.PNG
How can I get the formula in A2 to always refer to the location A1, even if A1 is moved somewhere else?
Bookmarks