Forum Discussion

MattKW1's avatar
MattKW1
Occasional Reader
Dec 18, 2025

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

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    Hi

    On your other sheet in B3:

    =INDIRECT( "Orig!A" & QUOTIENT( ROW(B3), 5 ) +3 )

    Merry Christmas 2 

Resources