title: Transpose and copy to row to column
body: <p>I have a row of data in say A1:AA1 in worksheet A. In worksheet B I have a range for data from A1:A25. I need the data from the row 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>