Ok, we are close. I have a simple formula: '2018'!N3. When I copy it to the cell in the next row, I want it to read '2018'!O3. But instead, it reads '2018'!N4. Now, by using the $ before the 3 as in '2018'!N$3, when I copy to the next row it reads '2018'!N$3. The $ keeps the 3 from changing to 4, but how to I get the N to change to O?
|