I am trying to copy cells from one worksheet to another but I want to
transpose them so that the same data shows horizontally rather than
vertically on the new sheet. I want the data to be linked to the first sheet
so that if I change the info on the first sheet it will automatically change
on the second sheet. There are a large number of cells involved. I've done
the normal Paste Special, transpose but it doesn't seem to work.

Any suggestions? Thanks,