software

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.

Hi Shannon,
How about Transpose, depending on your data and what
you are actually copying.

see Help, Transpose rows to columns or columns to rows
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

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

Hi Dave,
Problem is I am not copying, I am hitting the quot;=quot; button and creating a
formula reference to another tab, so Transpose is not a option. I asked
someone here and they thought about some quot;Rotatequot; function. Does Rotate
exist?

Thanks

quot;David McRitchiequot; wrote:

gt; Hi Shannon,
gt; How about Transpose, depending on your data and what
gt; you are actually copying.
gt;
gt; see Help, Transpose rows to columns or columns to rows
gt;
gt;
gt;
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Shannonquot; gt; wrote in message ...
gt; gt; I am trying to link a data from another worksheet and extend that formula to
gt; gt; the right. However the data on that other worksheet is vertical not
gt; gt; horizontal. Is there a way for a link to extend horizontally from a vertical
gt; gt; data table? I can not change the orientation of the data.
gt;
gt;
gt;
gt;

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 MVPOn Mon, 19 Dec 2005 14:57:02 -0800, quot;Shannonquot;
gt; wrote:

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