Fill

[ADK]

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?

 

[Gord Dibben]

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

Enter is A1 or sheet2 and copy across.


Gord Dibben MS Excel MVP