Forum Discussion
MattKW1
Dec 18, 2025Occasional Reader
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 origi...
Lorenzo
Dec 19, 2025Silver Contributor
Hi
On your other sheet in B3:
=INDIRECT( "Orig!A" & QUOTIENT( ROW(B3), 5 ) +3 )EDIT: OR - safer:
=INDIRECT( "Orig!A" & QUOTIENT( ROW(B3)-ROW(B$3) +1, 5 ) +ROW(Orig!A$3) )Merry Christmas 2