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.