View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shannon
 
Posts: n/a
Default 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.