How do I copy a column into a row and keep the links to other workbooks so
that they update automatically? When I transpose when pasting I lose the
option to paste the link.