copying cells
 

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?

copying cells
 

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
---
"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?

copying cells
 

Somewhere on the other sheet:

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

copying cells
 

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?