Bernard

=INDIRECT("Sheet2!A"&COLUMN(A1))

Enter in any cell in Sheet1 and drag across.


Gord Dibben MS Excel MVP


On Sat, 12 Aug 2006 11:31:01 -0700, Bernard Modlinsky <Bernard
wrote:

I'm looking for a way to to quickly transfer data from cells in a column in
one sheet of an excel workbook to cells in a row in another sheet of the same
workbook. It's a simple matter if the cells in both sheets are in columns as
you can just make the first cell equal the first cell of the column that you
want the data to come from, and then drag and drop from that one down to the
other cells in that column til you have transferred all the information
required. I haven't worked out how to do this when you are going from column
to row or vice-versa. Anybody got any ideas, please.