drag cells horizontally on sheet 1 and pull data from vertical cells in sheet 2

I have a simple task I believe. I need to reference cells horizontally in sheet 1 with cells vertically in sheet 2. The sheet is too big to do by selecting each cell individually.

Try something like

=INDEX(Sheet1!$1:$1,ROWS($A$1:$A1))

Okay, suppose your cells are in column A in sheet 2 and you want them in row 1 of sheet 1. Put this in A1 of sheet 1:

=INDEX('sheet 2'!A:A,columns($A:A))

then copy across.

Hope this helps.

Pete

I have this so far. When I copy across, it just keeps repeating the value in the first cell.

=INDEX(Sheet2!$A$2:$A$16,COLUMN($A$2:$A$16))

I presume you are replying to me. That is not the same formula that I gave you. Use this:

=INDEX(Sheet2!$A$2:$A$16,COLUMNS($A:A))

Hope this helps.

Pete

It should be COLUMNS (plural), not COLUMN, the second part of the range should also be relative ($ ommitted for the end column)

=INDEX(Sheet2!$A$2:$A$16,COLUMNS($A$2:A$2))