Forum Discussion

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

excel

Formulas and Functions

office 365

Lorenzo

Silver Contributor

Dec 19, 2025

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