Paste transpose and link at the same time

[Phippsy]

Is there any way of doing this? Once you click on Transpose the link button
becomes inactive.
Thanks

 

[Max]

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]

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]

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

 

[Phippsy]

Worked second time! Must have done something wrong. Thanks so much

 

[Max]

No prob. Glad you got it up over there.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik