Referencing column to row across worksheets
 

I have a column of numbers in one worksheet that I want to use in a row of
another sheet as a relative reference. Changes in the first sheet should
affect the second.

How do I do this?

Referencing column to row across worksheets
 

Try the below in Sheet2 and copy across....with data in Sheet1 A2:A10..
Adjust the range to suit

=INDEX(Sheet1!$A$2:$A$10,COLUMN(A1))

--
Jacob


"LZCenter" wrote:

I have a column of numbers in one worksheet that I want to use in a row of
another sheet as a relative reference. Changes in the first sheet should
affect the second.

How do I do this?