I just have a preference for the non-volatile Index():

Data on Sheet1, in Column A.

Enter this anywhere in another sheet. and copy across as needed:

=INDEX(Sheet1!$A:$A,COLUMNS($A:A))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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.