Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling in worksheet cell references
I have some large data tables that I need to rearrange in a differenct way.
I would like to be able to reference a cell from a different worksheet which are not contiguous, but are separated by a constant integral number of cells, e.g. 'Sheet1'!C5, 'Sheet1'!C53, 'Sheet1'!C101, 'Sheet1'!C149, etc. Here, obviously, the separation integer is 48. Is there any way that I can use an auto fill function of some kind to load the first few references, and then fill the rest of the cells to use the same separation? Thanks! Bill H. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling in worksheet cell references
Enter:
=INDIRECT("Sheet1!C" & (ROWS(A1:$A$1)-1)*48+5) in some cell and then copy down. -- Gary''s Student - gsnu200854 "Wavequation" wrote: I have some large data tables that I need to rearrange in a differenct way. I would like to be able to reference a cell from a different worksheet which are not contiguous, but are separated by a constant integral number of cells, e.g. 'Sheet1'!C5, 'Sheet1'!C53, 'Sheet1'!C101, 'Sheet1'!C149, etc. Here, obviously, the separation integer is 48. Is there any way that I can use an auto fill function of some kind to load the first few references, and then fill the rest of the cells to use the same separation? Thanks! Bill H. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling in worksheet cell references
=OFFSET(Sheet1!C$5,(ROW(A1)-1)*48,0) and copy down.
-- David Biddulph "Wavequation" wrote in message ... I have some large data tables that I need to rearrange in a differenct way. I would like to be able to reference a cell from a different worksheet which are not contiguous, but are separated by a constant integral number of cells, e.g. 'Sheet1'!C5, 'Sheet1'!C53, 'Sheet1'!C101, 'Sheet1'!C149, etc. Here, obviously, the separation integer is 48. Is there any way that I can use an auto fill function of some kind to load the first few references, and then fill the rest of the cells to use the same separation? Thanks! Bill H. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling in worksheet cell references
Thanks David, what do the three arguments in the OFFSET() function refer to?
Thanks again. "Wavequation" wrote: I have some large data tables that I need to rearrange in a differenct way. I would like to be able to reference a cell from a different worksheet which are not contiguous, but are separated by a constant integral number of cells, e.g. 'Sheet1'!C5, 'Sheet1'!C53, 'Sheet1'!C101, 'Sheet1'!C149, etc. Here, obviously, the separation integer is 48. Is there any way that I can use an auto fill function of some kind to load the first few references, and then fill the rest of the cells to use the same separation? Thanks! Bill H. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling in worksheet cell references
Try typing the word OFFSET into Excel help.
-- David Biddulph Wavequation wrote: Thanks David, what do the three arguments in the OFFSET() function refer to? Thanks again. "Wavequation" wrote: I have some large data tables that I need to rearrange in a differenct way. I would like to be able to reference a cell from a different worksheet which are not contiguous, but are separated by a constant integral number of cells, e.g. 'Sheet1'!C5, 'Sheet1'!C53, 'Sheet1'!C101, 'Sheet1'!C149, etc. Here, obviously, the separation integer is 48. Is there any way that I can use an auto fill function of some kind to load the first few references, and then fill the rest of the cells to use the same separation? Thanks! Bill H. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change column references when filling down a formula | Excel Discussion (Misc queries) | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Cell References from old worksheet to new worksheet. | Excel Discussion (Misc queries) | |||
filling information from one cell and filling another. | Excel Worksheet Functions | |||
VB Scripting/Macro - Filling/Editing Worksheet References | New Users to Excel |