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?