transfer data into row cells from column cells in Excel

B

Bernard Modlinsky

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

Gord Dibben

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
 
R

RagDyeR

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
 
Top