Shannon

Sheet1 has the data in Column A

Enter this formula in Sheet2 A1

=INDEX(Sheet1!$A:$A,COLUMN()) drag/copy across row 1.

Note: a sheet has 256 columns so you're limited.


Gord Dibben Excel MVP


On Mon, 19 Dec 2005 14:57:02 -0800, "Shannon"
wrote:

I am trying to link a data from another worksheet and extend that formula to
the right. However the data on that other worksheet is vertical not
horizontal. Is there a way for a link to extend horizontally from a vertical
data table? I can not change the orientation of the data.