drag and fill nightmares

[nightguy]

Two related questions, please.

(1) I have data in cells B1:H1, say.
In A2, I would like to reference B1.
In A3, I would like to reference C1.
In A4, I would like to reference D1.
and so on.
Is there any way of using a drag or fill to complete the rest of the references?

(2) I have data in cells B1:H1, say.
In B2, I would like to reference H1.
In C2, I would like to reference G1.
In D2, I would like to reference F1.
and so on.
Again, is there a way to drag and fill this?

Thanks very much for your help!

[Mark W.]

(1) Enter =OFFSET($A$1,,ROW(A1)) into cell A2 and fill down.

(2) Enter =OFFSET($H$1,,8-COLUMN(H1)) into cell B2 and fill right.

[Chris Davison]

Hi Mark,

wow

OFFSET

they say you learn something new every day... too right on this board !

My question : does the OFFSET function only apply to the current worksheet ? The help file says errors if it points past the edge of the sheet, does this mean you can't still use it in conjunction with naming another sheet in the workbook

like : offset(sheet2!A1,1,2,3,4)

thanks mate
Chris


==========

hey, ignore this, I just tried it with the function wizard and it does. Function-of-the-day award in my book. Thanks Mark.

[ This Message was edited by: Chris Davison on 2002-02-20 13:18 ]

[nightguy]

Thanks very much for your help. OFFSET seems like a very useful function!