Filling in worksheet cell references

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.
 
G

Gary''s Student

Enter:

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

in some cell and then copy down.
 
G

Gary''s Student

Enter:

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

in some cell and then copy down.
 
W

Wavequation

Thanks David, what do the three arguments in the OFFSET() function refer to?
Thanks again.
 
W

Wavequation

Thanks David, what do the three arguments in the OFFSET() function refer to?
Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying from another worksheet 4
Fill cells from non-adjacent cells 2
Selecting a diff. worksheet but same cell references using Validat 1
Absolute Worksheet reference number 4
Retain cell references when column moves 4
Copying formulas, relative and absolute cell references 3
Query on Use of Absolute References 2
Using references in functions based upon values in other cells 1

Top