Microsoft Office Forums - View Single Post - Formula Copy Row 2 Row But Next Column In Formula From Another Tab

Thread: Formula Copy Row 2 Row But Next Column In Formula From Another Tab

View Single Post

Old

04-15-2018, 10:35 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,097

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor 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