A 3rd (different) way

=OFFSET(Jan!$r$9,ROWS($1:1)*14,0)
and Copy down


"waterguy" wrote:

I am trying to create a column of cells referring to another worksheet.
There is a sequence to the cells but, unfortunately, the next cell down
refers to a cell 14 cells down in the other sheet. ex. jan!r9 for first
entry, next entry down is jan!r23, then jan!r37. Any suggestions?