transposing and linking cells

G

gobstopper

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.
 
A

Ardus Petus

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
 
Top