Forum Discussion
Non-Consecutive Cell Referencing
Hi, folks.
I'm attempting to create a spreadsheet that contains links from consecutive cells to consecutive cells in another worksheet that are separated by 5 intervening cells.
I'll call the original consecutive spreadsheet "Orig" (for original).
So, I know that if I put "='Orig'!A3" in cell B3 and then copy that down, it will update the relative formula consecutively, i.e. B3='Orig'!A3, B4='Orig'!A4, B5='Orig'!A5, B6='Orig'!A6.... that much I get.
What I need to do is find a way to do the same thing, but to increase the resulting link.....so that if I copied the formula down column B I would get: B3='Orig'!A3, B8=Orig'!A4, B13='Orig'!A6', etc so that the new worksheet is moving down 5 cells relative to the Orig sheet consecutive order.
I've read where someone used a formula using the INDIRECT function but that's beyond my beginner level.
Many thanks, and merry Xmas to all!
1 Reply
- LorenzoSilver Contributor
Hi
On your other sheet in B3:
=INDIRECT( "Orig!A" & QUOTIENT( ROW(B3), 5 ) +3 )Merry Christmas 2