>>In addition to learning about absolute and relative references, if you're doing anything tricky with Excel you might want to switch to R1C1 notation: https://bettersolutions.com/excel/formulas/cell-references-a1-r1c1-notation.htm
>
>Thanks, this is a great reference.

Typical next step for ambituos sheets: after $ or RxCx: read up on Indirect function.
Think of it as vfp eval() in an Excel habitat - quite powerful...
(But be careful: as side effect can disturb readingfollowing program flow as much as code full of Goto..)