Increase row of cell reference to another worksheet by 20

Cell 'G7' of 'Sheet1' contains '=Sheet2!F17'. I would like for
.....'G8' ...........................'=Sheet2!F37', and
.....'G9'............................'=Sheet2!F57', etc.
Each time the row of 'Sheet1' increases by 1, the row of 'Sheet2' increases by 20.

Any help is greatly appreciated.

Hi,

in cell G8 type following :
=OFFSET(Sheet2!$F$17,20*(ROW()-ROW($G$7)),0)
and copy down ...

Hope it 's working OK ...

Cheers
Carim

Thanks for your help.

You saved me countless hours.

Glad I could help ...

Thanks for the feedback

Carim