Linking Sheets - Columns to Rows

timKi

New Member
Joined
Oct 3, 2006
Messages
2
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.
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,871
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Select Sheet2!A1:E1 and type =TRANSPOSE(Sheet1!A1:A5) and press Ctrl-Shift-Enter.
 

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,749
Highlight cells A1:E1 in sheet2 and type this in the formula bar:

=Transpose(Sheet1!A1:A5)

and confirm with CTRL+SHIFT+ENTER
 

Watch MrExcel Video

Forum statistics

Threads
1,114,091
Messages
5,545,906
Members
410,711
Latest member
Josh324
Top