How do I copy a column into a row and keep the links?

[Gaz1]

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.

[RagDyeR]

Column is on Sheet1, starting from A1.

On Sheet2, enter this formula wherever you wish to start your duplicated
row:

=INDEX(Sheet1!$A:$A,COLUMNS($A:A))

And copy across as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Gaz1" <[email protected]> wrote in message
news:[email protected]...
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.