reference to other sheet
 

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."

reference to other sheet
 

Try this:

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

Copy down as needed.

Biff

"Bakerman" <whirlpool at skynet.be wrote in message
...
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."

reference to other sheet
 

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

"Bakerman" wrote:

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."