G
Guest
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,
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,