 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Links / November 2003Tranpose a link
I have an excel spreadsheet(office 97 version) where I would like to link fields on one sheet to another sheet in the same workbook, except I need the linked fields to be transposed into the second sheet. If you use the paste special command, and choose Transpose, the paste link button will turn to a ghost, and can't be selected. Any help is appreciated. > I have an excel spreadsheet(office 97 version) where I would like to link fields > on one sheet to another sheet in the same workbook, except I need the linked fields > to be transposed into the second sheet. > If you use the paste special command, and choose Transpose, > the paste link button will turn to a ghost, and can't be selected. Any help is appreciated. One way would be: Name the source range "Original" Select the destination range and array-enter (using Ctrl+Shift+Enter) the formula =TRANSPOSE(Original) Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.