Try this formula on Sheet2:

=OFFSET(sheet1!$A$1,0,COLUMN()-1,0)

Then copy across your columns.

HTH,
Elkar


"Terry Bennett" wrote:

Not sure if there is an easy way around this ...

From time to time I seem to find myself needing to create cell references
between sheets in the same workbook where the source data is stored
'vertically', yet I need the results to be shown 'horizontally'.

As a simple example, if Sheet 1 contains data in column A, cells 1 - 100,
and I want to link this to cells in Sheet 2 in Row 1 (ie; A1, B1, C1, etc),
how can I do this other than manually typing the cell references each time?

On Sheet 2 I need to see - A1: =Sheet1!A1, B1: =Sheet1!A2, etc.

Thanks!