Tansposed Link in Excel

N

neil

Hi,

I've been trying to transpose a row of data to a column in another sheet and
establish a link. But the "paste link" button in paste special doesn't work
along with the transpose button. Any light on this?

Thanks

Neil
 
J

Jim Rech

I'd suggest that you do a straight paste link and then use cut/paste to
change the orientation of the formulas a cell at a time. If the range is
huge the time it that's to write a macro may be worth it.

--
Jim Rech
Excel MVP
| Hi,
|
| I've been trying to transpose a row of data to a column in another sheet
and
| establish a link. But the "paste link" button in paste special doesn't
work
| along with the transpose button. Any light on this?
|
| Thanks
|
| Neil
 
Top