copying cells

[waterguy]

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?

 

[Max]

One way
Put this in the start cell: =OFFSET(jan!$R$9,ROWS($1:1)*14-14,)
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik

 

[Gary''s Student]

Somewhere on the other sheet:

=INDIRECT("jan!r"&(ROWS(A1:A$1)-1)*14+9) and copy down

 

[JMay]

A 3rd (different) way

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