close
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.
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
quot;gobstopperquot; gt; a écrit dans le message
de ...
gt; I need to transpose and link the contents of cells from one worksheet onto
gt; another worksheet but I can't seem to do this with the paste special
command.
gt; If I select transpose it greys out link cells. Thanks in advance.
全站熱搜
留言列表
