copying cells

waterguy · Nov 20, 2008

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 · Nov 20, 2008

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 · Nov 20, 2008

Somewhere on the other sheet:

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

JMay · Nov 20, 2008

A 3rd (different) way

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

copying cells

waterguy

Max

Gary''s Student

JMay