reference to other sheet

[Bakerman]

in sheet2 I want A1 to refer to A23 of sheet1, so I fill in "=sheet1'!A23",
this will the put the contents of cell A23 in sheet1 in cell A1 of sheet2
in sheet2 I want A2 to refer to A46 of sheet1, so I fill in "=sheet1'!A46",
this will the put the contents of cell A46 in sheet1 in cell A2 of sheet2

in general in sheet2 I want An to refer to A23n of sheet1

Is there an easy way to fill in these formulas in sheet2?
I would like to use the fill handle but don't know how. When I use it the
referenced cell row is incremented with 1 iso 23.

 

[T. Valko]

Try this:

=OFFSET(Sheet1!A$23,(ROWS($1:1)-1)*23,)

Copy down as needed.

Biff

 

[BoniM]

=OFFSET(Sheet1!$A$1,ROW(1:1)*23-1,0)
enter in cell A1 and copy down as needed.