Dragging Formulae down the sheet

[Paul]

Hi,

In a100 I have a formula = a6, in a101 I want =a12 and in
a102 =a18. Is there any neat way I can write the formula
so I can simply drag it down the column from a100?

Thanks for looking!

Paul

 

[Andy B]

Hi

Try this in A101::
=OFFSET(INDIRECT(A100),6,0)

Andy.

 

[Frank Kabel]

Hi
one way: put the following formula in A100
=OFFSET($A$6,(ROW()-100)*6,0)
and copy down

 

[Arvi Laanemets]

Hi

Into A100 enter the formula

=OFFSET(A$6,(ROW(A1)-1)*6,0)