paste link and transpose simultaneously

[Kate]

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

Thanks in advance.

 

[Rafael Ortiz]

You might be able to accomplish what you need with the TRANSPOSE function.

MRO

 

[Dave Peterson]

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.

 

[Morgan]

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