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!
(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!