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

Thanks

"David McRitchie" wrote:

> 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: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Shannon" <Shannon@discussions.microsoft.com> wrote in message news:3FC12D26-D7E7-4C66-B233-CA5B693B8E2E@microsoft.com...
> > 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.
>
>
>
>