View Single Post
 
Old 04-16-2018, 03:37 PM
TimG TimG is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2018
Posts: 2
TimG is on a distinguished road
Default

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?
Reply With Quote