Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste transpose and link at the same time
Is there any way of doing this? Once you click on Transpose the link button
becomes inactive. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste transpose and link at the same time
Assume source data to be transposed is in Sheet1, within A1:C2
In another sheet, in any startcell, say in B2: =OFFSET(Sheet1!$A$1,COLUMNS($A:A)-1,ROWS($1:1)-1) Copy B2 across/fill down to C4 to create a transpose dynamic to changes in the source range in Sheet1. Just change the "Sheet1!$A$1" anchor in the OFFSET to suit the top-left cell of the source range to be transposed. Voila? click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Phippsy" wrote: Is there any way of doing this? Once you click on Transpose the link button becomes inactive. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste transpose and link at the same time
This only seems to work if it is on the same sheet. If it is on a different
sheet it comes up with 'TRUE' Any further ideas? Thanks "Max" wrote: Assume source data to be transposed is in Sheet1, within A1:C2 In another sheet, in any startcell, say in B2: =OFFSET(Sheet1!$A$1,COLUMNS($A:A)-1,ROWS($1:1)-1) Copy B2 across/fill down to C4 to create a transpose dynamic to changes in the source range in Sheet1. Just change the "Sheet1!$A$1" anchor in the OFFSET to suit the top-left cell of the source range to be transposed. Voila? click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Phippsy" wrote: Is there any way of doing this? Once you click on Transpose the link button becomes inactive. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste transpose and link at the same time
"Phippsy" wrote:
This only seems to work if it is on the same sheet. If it is on a different sheet it comes up with 'TRUE' .. The earlier expression works. Tested a thousand times before responding. Give it another try .. If your source sheetname contains a space(s), eg: Check Sheet then you need apostophies for the anchor, viz. in any startcell, in the other sheet, copied across/down: =OFFSET('Check Sheet'!$A$1,COLUMNS($A:A)-1,ROWS($1:1)-1) Success, finally? Click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste transpose and link at the same time
Worked second time! Must have done something wrong. Thanks so much
"Max" wrote: "Phippsy" wrote: This only seems to work if it is on the same sheet. If it is on a different sheet it comes up with 'TRUE' .. The earlier expression works. Tested a thousand times before responding. Give it another try .. If your source sheetname contains a space(s), eg: Check Sheet then you need apostophies for the anchor, viz. in any startcell, in the other sheet, copied across/down: =OFFSET('Check Sheet'!$A$1,COLUMNS($A:A)-1,ROWS($1:1)-1) Success, finally? Click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste transpose and link at the same time
No prob. Glad you got it up over there.
-- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Phippsy" wrote in message ... Worked second time! Must have done something wrong. Thanks so much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I "paste link", and "transpose" at the same time? | Excel Discussion (Misc queries) | |||
Transpose and Paste Link | Excel Worksheet Functions | |||
How can I transpose a paste link? | Excel Discussion (Misc queries) | |||
How can I transpose a paste link? | Excel Discussion (Misc queries) | |||
how do I transpose and paste a link in excel | Excel Worksheet Functions |