paste link and transpose simultaneously

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

Does anyone know if it is possible to paste links and
transpose data simultaneously?

Thanks in advance.
 
Are you VILLABILLA? (similar question in .excel)

How about doing the paste in few steps?

1. Copy your range
2. Find an unused area and paste|special|Paste link
3. With the pasted area selected,
change = to $$$$$=
(via Edit|Replace)
Now, all your formulas are values
4. Copy this new range
Select the real home and edit|Paste Special|Transpose
5. Finally,
change $$$$$= back to =
And your formulas will reappear.
 
Kate,

I've used formulas to link and transpose. For example:

=TRANSPOSE(Sheet1!$A$2:$B$10)

Put your formula in the first cell of your target sheet/range, then
select the rest of the target range, press F2, then Ctrl-Shift-Enter.
When changes are made to Sheet1!A2:B10, they will be reflected in the
new range.

Hope this helps.

Morgan
 
Back
Top