Autofill from column to row
 

I have a worksheet with data in a column and want the data on another sheet
in a row, sorted in another way. I tried to use autofill to get data from
every 25th cell in the column to the row on the other sheet, ['sheet 1'!F2"]
in cell B2, ['sheet 1'!F27] in cell C2, ['sheet 1'!F52] in cell D2 and so on.
Excel autofill wont understand what I want, is there any other way of solving
this?

One way

In the destination sheet:

Put in B2:

=OFFSET('Sheet 1'!$F$2,COLUMNS($A$1:A1)*25-25,)

Copy B2 across to D2

B2:D2 will return the desired contents, viz.:

in B2: ='Sheet 1'!F2
in C2: ='Sheet 1'!F27
in D2: ='Sheet 1'!F52
etc

(at intervals of each 25th cell down)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Magnus Holmberg" <Magnus wrote in
message ...
I have a worksheet with data in a column and want the data on another
sheet
in a row, sorted in another way. I tried to use autofill to get data from
every 25th cell in the column to the row on the other sheet, ['sheet
1'!F2"]
in cell B2, ['sheet 1'!F27] in cell C2, ['sheet 1'!F52] in cell D2 and so
on.
Excel autofill wont understand what I want, is there any other way of
solving
this?