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