Paste transpose and link at the same time

  • Thread starter Thread starter Phippsy
  • Start date Start date
P

Phippsy

Is there any way of doing this? Once you click on Transpose the link button
becomes inactive.
Thanks
 
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
 
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
 
Phippsy said:
This only seems to work if it is on the same sheet.
If it is on a different sheet it comes up with 'TRUE' ..
Click to expand...

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