Dragging formulas

[Derrick]

I've a column which I want to drag info from another
spreadsheet. Rather than incremental in row #, it's sort
of a transposed. Example as follows:

A1 = Sheet5!A15
A2 = Sheet5!B15
A3 = Sheet5!C15
A4 = Sheet5!D15

Can this be done using a formula and drag down?
Thanks.

 

[acw]

Derrick

Have a look at the TRANSPOSE function. I has to be array
entered and cover the entire range of both the input and
output areas.


Tony

 

[Leo Heuser]

Derrick

This formula will do the job, assuming it's entered
in A1:

=OFFSET(Sheet5!$A$15,0;ROW()-ROW($A$1))

Drag down to copy.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only, please.