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

G

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

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!
=====================================================

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