sumesh56

Senior Member

Posts: 118

how to link ranges into transpose style?

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

Attached Files

	LINK-1-COMPILATION.zip (7.6 KB, 21 views)
	LINK-2-MARKREGISTER.zip (9.0 KB, 25 views)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Transpose link	Ana via OfficeKB.com	Excel Worksheet Functions	5	June 3rd 10 12:42 PM
Link and transpose?	jaimek	Excel Discussion (Misc queries)	2	August 20th 08 11:29 PM
How can I transpose a paste link?	rpcar	Excel Discussion (Misc queries)	2	September 1st 05 01:45 AM
How can I transpose a paste link?	rpcar	Excel Discussion (Misc queries)	2	September 1st 05 12:31 AM
Transpose Dynamic Ranges	Ozbobeee[_2_]	Excel Programming	2	July 27th 04 09:43 AM

All times are GMT +1. The time now is 05:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us