cell references

  • Thread starter Thread starter Sandi
  • Start date Start date
S

Sandi

does anyone know how to enter a formula to link two pages
when the cell reference always increases by 7 rows.
Right now I have to type the formula in each cell, I am
trying to figure out how I can copy the formula across.

For example
Cell A1 ='tommy'!K10
Cell B1 ='tommy'!K17
Cell C1 ='tommy'!K24
etc.

Any suggestions?
 
One way

=OFFSET(Tommy!$K$10,ROW(1:1)*7-7,)

don't insert rows above the formula or it will be offset wrongly
 
Sandi,
If I'm not mistaken, if you type 3 or 4 in you can
highlight all of them (the 3 or 4 that you typed)and click
the solid black box in the bottom right corner of the
cells and drag it down. Once you begin to create a
series, it remembers that and should continue it for you.
 
Peo Sjoblom said:
One way

=OFFSET(Tommy!$K$10,ROW(1:1)*7-7,)

don't insert rows above the formula or it will be offset wrongly

--

Regards,

Peo Sjoblom
Click to expand...

Very neat! I wish I'd thought of that.

BTW the OP mentioned A1, B1, C1, etc, rather than A1, A2, A3. A formula that
can be copied across rather than down is:

=OFFSET($K$10,COLUMN(A1)*7-7,)

Geoff
 
Back
Top