When you copy a row of cells from one work book then go to another workbook, go to paste special, then select transpose, the past link option goes away.
Why is that and is their anyway around this problem.
I need to copy from a row and paste then link into a column a bunch of times.
Any suggestion?
Thanks
Bookmarks