Assuming source data is vertical in Sheet1 A1:A99
In sheet2 row1 column A, enter:
=INDEX(Sheet1!A1:A99;COLUMN())
then copy to the right

HTH
--
AP

"gobstopper" a écrit dans le message
de ...
I need to transpose and link the contents of cells from one worksheet onto
another worksheet but I can't seem to do this with the paste special
command.
If I select transpose it greys out link cells. Thanks in advance.