| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying cells
Somewhere on the other sheet:
=INDIRECT("jan!r"&(ROWS(A1:A$1)-1)*14+9) and copy down -- Gary''s Student - gsnu200814 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Cells | New Users to Excel | |||
| Copying Cells | Excel Discussion (Misc queries) | |||
| Copying Cells | Excel Worksheet Functions | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
| Excel should allow cloaking of certain cells when copying cells b. | Excel Worksheet Functions | |||
Linear Mode
