Mike,

Contact me by private email, and I will send an add-in that I wrote that
will add a Transpose Links option to the right-click cell menu.

HTH,
Bernie
MS Excel MVP

"Mike" wrote in message
...
i have a range of data in one worksheet that is vertical. I need to link
this data to another worksheet in a horizontal format. when click
"transpose" the "paste link" button greys out. is the only way to move
this
data a manual process? hope not, as i have a LOT of it to move.