Filling in worksheet cell references

  • Thread starter Thread starter Wavequation
  • Start date Start date
W

Wavequation

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.
 
Enter:

=INDIRECT("Sheet1!C" & (ROWS(A1:$A$1)-1)*48+5)

in some cell and then copy down.
 
Enter:

=INDIRECT("Sheet1!C" & (ROWS(A1:$A$1)-1)*48+5)

in some cell and then copy down.
 
Thanks David, what do the three arguments in the OFFSET() function refer to?
Thanks again.
 
Thanks David, what do the three arguments in the OFFSET() function refer to?
Thanks again.
 
Back
Top