Hi David

With your source data in row 1, enter in A2
=INDEX($1:$1,1,ROW(A1))
and copy down

--
Regards

Roger Govier


"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?