how to link ranges into transpose style?

S

sumesh56

I want to link two worksheets. worksheet1 is LInk-1-compilation.xlsx
and ws2 is Link-2-mark register.xlsx.
i want to link the contents from link-1 , cell c3:i3 to link-2 cell
E3:E9. the thing is the data has to be taken in the manner that it is
transposed.link-1 is the master file.how can i do this? thanks.
the sample files are attached herewith. thanks

+-------------------------------------------------------------------
|Filename: LINK-1-COMPILATION.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=827
|Filename: LINK-2-MARKREGISTER.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=828
+-------------------------------------------------------------------
 

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

how to append a phrase to a cellcontent 4
Dropdownlist and Vlookup 6
Permanently link formula references to Column Names and not Column Cell Numbers 1
Parsing 2
how to get the total of two lines 3
countif with some conditions 7
If function..please help 1
Look UP and then caluclation with IS ERROR 3

Top