Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-15-2018, 09:24 AM
TimG TimG is offline Formula Copy Row 2 Row But Next Column In Formula From Another Tab Windows 10 Formula Copy Row 2 Row But Next Column In Formula From Another Tab Office 2016
Novice
Formula Copy Row 2 Row But Next Column In Formula From Another Tab
 
Join Date: Apr 2018
Posts: 2
TimG is on a distinguished road
Question 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?
Reply With Quote
  #2  
Old 04-15-2018, 10:35 PM
xor xor is offline Formula Copy Row 2 Row But Next Column In Formula From Another Tab Windows 10 Formula Copy Row 2 Row But Next Column In Formula From Another Tab Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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.
Reply With Quote
  #3  
Old 04-16-2018, 03:37 PM
TimG TimG is offline Formula Copy Row 2 Row But Next Column In Formula From Another Tab Windows 10 Formula Copy Row 2 Row But Next Column In Formula From Another Tab Office 2016
Novice
Formula Copy Row 2 Row But Next Column In Formula From Another Tab
 
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
  #4  
Old 04-16-2018, 09:20 PM
xor xor is offline Formula Copy Row 2 Row But Next Column In Formula From Another Tab Windows 10 Formula Copy Row 2 Row But Next Column In Formula From Another Tab Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default 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.
Attached Files
File Type: xlsx TimG.xlsx (10.6 KB, 8 views)
Reply With Quote
Reply

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 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft