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

U

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link sheet with Condition 2
HELP!! How to formula the "sheet" link 2
Copying from one sheet to another 7
Copy contents to another sheet 4
Copy Data from 1 Sheet to Another 3
Sum per row and Average per column from a second sheet. 6
copying only selected data from Sheet 1 to Sheet 2 2
Using drop-down lists 4

Top