Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to copy cells horizontally to cells out of sequence
I have data in cells that are on Sheet1. This data is in Cells B2, B3, B4,
B5 etc (All Horizonally, ie staying in same row). I'm working on Sheet2 and would like to know how to take this data from Sheet1 and copy it to different cells on Sheet2, but have the data fall vertically. I can copy this once and repeat, but I am looking for a formula that will do this for me so I can copy it multiple times. Example: Sheet1, B2, will go to Sheet2, K4. Sheet1 C2, will go to Sheet2, K5 Sheet1 D2, will go to Sheet2, K6 Please help. |
#2
|
|||
|
|||
One way:
Enter this in K4 of Sheet2, and copy down as needed: =INDEX(Sheet1!$2:$2,ROWS($2:3)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "brantty" wrote in message ... I have data in cells that are on Sheet1. This data is in Cells B2, B3, B4, B5 etc (All Horizonally, ie staying in same row). I'm working on Sheet2 and would like to know how to take this data from Sheet1 and copy it to different cells on Sheet2, but have the data fall vertically. I can copy this once and repeat, but I am looking for a formula that will do this for me so I can copy it multiple times. Example: Sheet1, B2, will go to Sheet2, K4. Sheet1 C2, will go to Sheet2, K5 Sheet1 D2, will go to Sheet2, K6 Please help. |
#3
|
|||
|
|||
do you want b2 b3 b4 etcto be copied c5 c6 c7 etc in some on some other
sheet copy b2 b3 b4 (edit-copy) and go the new sheet new cell and click edit-pastspecial and click <transpose at the bottom of paste special window "brantty" wrote in message ... I have data in cells that are on Sheet1. This data is in Cells B2, B3, B4, B5 etc (All Horizonally, ie staying in same row). I'm working on Sheet2 and would like to know how to take this data from Sheet1 and copy it to different cells on Sheet2, but have the data fall vertically. I can copy this once and repeat, but I am looking for a formula that will do this for me so I can copy it multiple times. Example: Sheet1, B2, will go to Sheet2, K4. Sheet1 C2, will go to Sheet2, K5 Sheet1 D2, will go to Sheet2, K6 Please help. |
#4
|
|||
|
|||
Hi
Since you say your source date is on the same row, I guess you mean B2:E2 as opposed to B2:B5 Copy cells B2:E2 Move to Sheet2, K4 Paste SpecialTranspose Alternatively, you could enter the following formula in Sheet2 cell K4 =OFFSET(Sheet5!$B$2,COLUMN()-11,ROW()-4) Copy down column K as far as you wish, then across the sheet through columns L onward, if you want to pick up data from B3:E3 etc. Regards Roger Govier brantty wrote: I have data in cells that are on Sheet1. This data is in Cells B2, B3, B4, B5 etc (All Horizonally, ie staying in same row). I'm working on Sheet2 and would like to know how to take this data from Sheet1 and copy it to different cells on Sheet2, but have the data fall vertically. I can copy this once and repeat, but I am looking for a formula that will do this for me so I can copy it multiple times. Example: Sheet1, B2, will go to Sheet2, K4. Sheet1 C2, will go to Sheet2, K5 Sheet1 D2, will go to Sheet2, K6 Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy a block of cells | Excel Discussion (Misc queries) | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
How to copy block of cells and keep grouping? | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
loan calculator cells, P&I formulas do not copy to second cloumn | Excel Worksheet Functions |