Linking Sheets - Columns to Rows

[timKi]

How do I link a column of figures (in Sheet 1) say A1 to A5, with the same figures transposed into a Row in Sheet 2, say A1 to E1?
I can only do it one cell at a time - That is, click = on sheet 2, A1 then click on sheet 1, then A1, click = on Sheet 2,B1 then click on A2 Sheet1 etc.
I am sure there is a quick way of doing this, but what is it?
The 2 Sheets must be linked, so copying the column in Sheet 1 & pasting (special – transpose) does not work because this does not link the 2 Sheets.

 

[Peter_SSs]

timKi

Welcome to the Mr Excel board!

Try something like this. In Sheet 2 A1 (copied across):
=INDEX('Sheet 1'!$A$1:$A$5,COLUMNS($A1:A1))

 

[GlennUK]

Select Sheet2!A1:E1 and type =TRANSPOSE(Sheet1!A1:A5) and press Ctrl-Shift-Enter.

 

[PATSYS]

Highlight cells A1:E1 in sheet2 and type this in the formula bar:

=Transpose(Sheet1!A1:A5)

and confirm with CTRL+SHIFT+ENTER

 

[timKi]

Excel Linked Sheets

Many thanks - that works!!!