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.

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.

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.

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.

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.