Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default transfer data into row cells from column cells in Excel

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.
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default transfer data into row cells from column cells in Excel

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 04:56 AM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
How to sort/update large excel db [email protected] Excel Discussion (Misc queries) 0 February 2nd 05 01:43 AM
getting data from 2 excel sheets automatically pinar Excel Worksheet Functions 0 November 9th 04 12:47 PM


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"