Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you extend a formula horizontally while the data is vertical
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you extend a formula horizontally while the data is vertical
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you extend a formula horizontally while the data is vertic
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" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you extend a formula horizontally while the data is vertical
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Any cell containing formula seen as data instead of formula | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |