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.

--
David

Homer J. Simpson: "It takes two to lie. One to lie and one to listen."