How Can i Link With one sheet to another sheet in Row to Column

[Upen Patel]

Hi Guys,
I want to Link with two sheet but in one sheet data is in row. Those
data Paste with Paste Special --- Paste Link in second sheet in column.
Please see below example.
Sheet 1 (Entered Data) Sheet 2 (I want to
paste in sheet)
A B C D E A B
C D E
1 Patel Upen Jr.Cl. 50 60 70 1 50
2 60
3 70

I have data as per sheet-1 & I want to do as per sheet-2 with using any
function.
Note : Please do not tips manually. I want to tips as on function.

Thanks in Advance

Upen Patel
Mehsana (North Gujarat)
India.

 

[Jacob Skaria]

Upan

--In sheet2 A1; try the below formula which picks data from Sheet2C1
--Once you copy this to cell A1..copy down as required and copy across..

=OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()+1,1,1)

If this post helps click Yes