title: Transpose column on one sheet to row on another, with linking
body: <p>I have a column of data in say A1:A10 in worksheet A.  In worksheet B I have a range for data from A1:J1.  I need the data from the column in worksheet A to be transposed into the data range in worksheet B.  I can Paste Special and paste in the values but I need the information in worksheet A to update automatically that in worksheet B.</p>
  
  <p>Any help or advice is appreciated.</p>