#1




Formula Copy Row 2 Row But Next Column In Formula From Another Tab
I have a formula in a spreadsheet that references a cell from another tab. When I copy that formula to the next row of my spreadsheet, I want the new formula to reference the value from the cell in the next column of the spreadsheet in that other tab, not from the cell in the next row of the spreadsheet in that other tab. Can I do that and how?

#2




Let's say you have your data in Sheet1!B8:I8 then try the following formula in the other tab:
=INDEX(Sheet1!$B$8:$I$8,,ROWS($1:1)) Copy down six rows. 
#3




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?

#4




Formula Copy Row 2 Row But Next Column In Formula From Another Tab
It seems to me that you haven't tried the formula in #2.
Take a look at the attached. 
Tags 
column, formula, row 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
If text in column then formula in other  Grubermen  Excel  1  09062017 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  05082017 08:00 AM 
Help With Copy Formula Down Macro  npalmer610  Excel Programming  4  03142016 01:15 PM 
Need help with dragging a formula and changing a reference column as I drag the formula.  LupeB  Excel  1  10222015 03:02 PM 
Excel copy formula  KMS  Excel  1  08162011 03:02 PM 