|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 24th, 2003, 09:16 PM
|
|||
|
|||
Tranpose 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.
|
|
#2
November 25th, 2003, 07:53 AM
|
|||
|
|||
|
Tranpose a link
Jim wrote:
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
