copying cells

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

Somewhere on the other sheet:

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

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying cells from on row in one wkbk to scattered cells in anthr	Memphis	Microsoft Excel Programming	1	10th Feb 2009 03:22 AM
copying cells by checking color of the cells	JJJ010101	Microsoft Excel Programming	1	24th Jan 2006 06:42 AM
How do I skip blank cells when copying over a range of cells?	=?Utf-8?B?dGF3ZWxscw==?=	Microsoft Excel Misc	2	7th Jun 2005 09:36 PM
Excel should allow cloaking of certain cells when copying cells b.	=?Utf-8?B?TERJIFdvb2R5?=	Microsoft Excel Worksheet Functions	1	11th Mar 2005 04:55 PM
Problem when copying cells that reference other cells	=?Utf-8?B?UmljaA==?=	Microsoft Excel Misc	2	19th Aug 2004 09:14 PM