Fill

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ADK - 13 Jul 2007 20:43 GMT

On sheet1, I have values in range A1:A4

On sheet2 I would like to start with A1 equals sheet1!A1
Then B1 = sheet1!A2

So basically, I want to rotate the values on the second sheet.
Sheet1 values are vertical
Sheet2 values taken from Sheet1 are horizontal

Any easy way to do this when using fill? ....special characters in formula?

Reply to this Message

Gord Dibben - 13 Jul 2007 20:57 GMT

=INDIRECT("Sheet1!A"&COLUMN(A1))

Enter is A1 or sheet2 and copy across.

Gord Dibben MS Excel MVP

>On sheet1, I have values in range A1:A4
>
[quoted text clipped - 6 lines]
>
>Any easy way to do this when using fill? ....special characters in formula?

Reply to this Message