Prevent Excel from updating absolute references when target is moved

"You can try Excel's INDIRECT() function:

INDIRECT(ref_text,a1)

For example, if you always want to refer to cell A1, use the following syntax in cell B2:

=INDIRECT(""A1"")

In this fashion, B2 will always be equal to what A1 returns. For more info on this function, visit this page."