Try something like:

Cell A1: =INDIRECT("Sheet2!A" & COLUMN(A1))

and drag across the columns

Regards

Trevor



"davidge" wrote in message
...
How do I link data from a horizontal to a vertical range when the ranges
are
in different worksheets of the same workbook. I have used the
=INDEX(xx:xx,
columns($A:A), rows(1:1))) formula when two different workbooks are
involved
-- and it works great. But, it doesn't work for the same workbook -- what
am
I doing wrong?