I hav a spreadhset with columns of different formulas similar to this formula
The problem is when I copy the formulas down, the $A2 should be changing to $A3, $A4, $A5 etcetera. I tried dragging it down, Goto and none of it is working. I don't want to manually change this for hundreds of rows and cells and columns.
How do I get the cell reference to change?
Excel Formula:
=IFERROR(__xludf.DUMMYFUNCTION("GoogleFinance($A2+1)"),52.4)
How do I get the cell reference to change?