|
|
|
|
#1
04-16-2018, 03:37 PM
|
|||
|
|||
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? 
|
|
| Tags |
| column, formula, row |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| If text in column then formula in other | Grubermen | Excel | 1 | 09-06-2017 06:35 AM |
| Is it possible to put a formula in a table column header to define the name of the column? | JacquesW | Excel | 3 | 05-08-2017 08:00 AM |
| Help With Copy Formula Down Macro | npalmer610 | Excel Programming | 4 | 03-14-2016 01:15 PM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
| Excel copy formula | KMS | Excel | 1 | 08-16-2011 03:02 PM |
Windows 10 
Office 2016
Hybrid Mode