| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying information from rows to columns
I am trying to copy the data in row 6 in a spreadsheet - data range - b6:aq6
in worksheet RN to the destination of column T in worksheet ALL. I am not being successful in making it copy across - can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying information from rows to columns
Copy your rows, then click in the destination cell where you want to copy.
Select Edit | Paste special. Tick the transpose box, then hit ok. "ked" wrote: I am trying to copy the data in row 6 in a spreadsheet - data range - b6:aq6 in worksheet RN to the destination of column T in worksheet ALL. I am not being successful in making it copy across - can this be done? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying information from rows to columns
Hi Danny:
I tried this however it doesn't completely work for me, because I notice when I change a date in the original sheet RN it doesn't copy into the sheet ALL that I copied to. Any suggestions? "DannyS" wrote: Copy your rows, then click in the destination cell where you want to copy. Select Edit | Paste special. Tick the transpose box, then hit ok. "ked" wrote: I am trying to copy the data in row 6 in a spreadsheet - data range - b6:aq6 in worksheet RN to the destination of column T in worksheet ALL. I am not being successful in making it copy across - can this be done? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying information from rows to columns
You asked for instructions to *copy*, and that's what DannyS gave you.
What you're describing here is actually looking to *link* cells, since you want changes in the original cells to be reflected in the "other" cells. This formula can be entered *anywhere*, and copied down as needed: =INDEX(RN!$6:$6,ROWS($1:2)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ked" wrote in message ... Hi Danny: I tried this however it doesn't completely work for me, because I notice when I change a date in the original sheet RN it doesn't copy into the sheet ALL that I copied to. Any suggestions? "DannyS" wrote: Copy your rows, then click in the destination cell where you want to copy. Select Edit | Paste special. Tick the transpose box, then hit ok. "ked" wrote: I am trying to copy the data in row 6 in a spreadsheet - data range - b6:aq6 in worksheet RN to the destination of column T in worksheet ALL. I am not being successful in making it copy across - can this be done? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying information from rows to columns
Hi RD -
When I enter the INDEX formula it merges rows 1 & 2 in my "ALL" document. If I want all the info in row 6, columns b thru aq to *index* over to my "ALL" document in Column T rows, 2 thru 42, how would I adjust your formula? I guess I'm a little confused on this. Sorry! KED "RagDyer" wrote: You asked for instructions to *copy*, and that's what DannyS gave you. What you're describing here is actually looking to *link* cells, since you want changes in the original cells to be reflected in the "other" cells. This formula can be entered *anywhere*, and copied down as needed: =INDEX(RN!$6:$6,ROWS($1:2)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ked" wrote in message ... Hi Danny: I tried this however it doesn't completely work for me, because I notice when I change a date in the original sheet RN it doesn't copy into the sheet ALL that I copied to. Any suggestions? "DannyS" wrote: Copy your rows, then click in the destination cell where you want to copy. Select Edit | Paste special. Tick the transpose box, then hit ok. "ked" wrote: I am trying to copy the data in row 6 in a spreadsheet - data range - b6:aq6 in worksheet RN to the destination of column T in worksheet ALL. I am not being successful in making it copy across - can this be done? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying information from rows to columns
I don't understand your meaning of <<< "merges" rows 1 and 2
The formula will perform *exactly* as you wish, with *no* revisions necessary! Copy and paste the formula into T2, Then, click on the "fill handle" and drag down to copy to T42. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ked" wrote in message ... Hi RD - When I enter the INDEX formula it merges rows 1 & 2 in my "ALL" document. If I want all the info in row 6, columns b thru aq to *index* over to my "ALL" document in Column T rows, 2 thru 42, how would I adjust your formula? I guess I'm a little confused on this. Sorry! KED "RagDyer" wrote: You asked for instructions to *copy*, and that's what DannyS gave you. What you're describing here is actually looking to *link* cells, since you want changes in the original cells to be reflected in the "other" cells. This formula can be entered *anywhere*, and copied down as needed: =INDEX(RN!$6:$6,ROWS($1:2)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ked" wrote in message ... Hi Danny: I tried this however it doesn't completely work for me, because I notice when I change a date in the original sheet RN it doesn't copy into the sheet ALL that I copied to. Any suggestions? "DannyS" wrote: Copy your rows, then click in the destination cell where you want to copy. Select Edit | Paste special. Tick the transpose box, then hit ok. "ked" wrote: I am trying to copy the data in row 6 in a spreadsheet - data range - b6:aq6 in worksheet RN to the destination of column T in worksheet ALL. I am not being successful in making it copy across - can this be done? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying information from rows to columns
what i mean is that when i copy the formula my row 2 &3 become row 2 in
column T, when i try to fill down - rows 4&5 merge together and so on all the way down that column. i'm very puzzled! "RagDyer" wrote: I don't understand your meaning of <<< "merges" rows 1 and 2 The formula will perform *exactly* as you wish, with *no* revisions necessary! Copy and paste the formula into T2, Then, click on the "fill handle" and drag down to copy to T42. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ked" wrote in message ... Hi RD - When I enter the INDEX formula it merges rows 1 & 2 in my "ALL" document. If I want all the info in row 6, columns b thru aq to *index* over to my "ALL" document in Column T rows, 2 thru 42, how would I adjust your formula? I guess I'm a little confused on this. Sorry! KED "RagDyer" wrote: You asked for instructions to *copy*, and that's what DannyS gave you. What you're describing here is actually looking to *link* cells, since you want changes in the original cells to be reflected in the "other" cells. This formula can be entered *anywhere*, and copied down as needed: =INDEX(RN!$6:$6,ROWS($1:2)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ked" wrote in message ... Hi Danny: I tried this however it doesn't completely work for me, because I notice when I change a date in the original sheet RN it doesn't copy into the sheet ALL that I copied to. Any suggestions? "DannyS" wrote: Copy your rows, then click in the destination cell where you want to copy. Select Edit | Paste special. Tick the transpose box, then hit ok. "ked" wrote: I am trying to copy the data in row 6 in a spreadsheet - data range - b6:aq6 in worksheet RN to the destination of column T in worksheet ALL. I am not being successful in making it copy across - can this be done? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying information from rows to columns
Open a brand new worksheet in the *same* workbook as "RN".
Copy and paste the formula into A1. Drag down to copy. What happens? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "ked" wrote in message ... what i mean is that when i copy the formula my row 2 &3 become row 2 in column T, when i try to fill down - rows 4&5 merge together and so on all the way down that column. i'm very puzzled! "RagDyer" wrote: I don't understand your meaning of <<< "merges" rows 1 and 2 The formula will perform *exactly* as you wish, with *no* revisions necessary! Copy and paste the formula into T2, Then, click on the "fill handle" and drag down to copy to T42. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ked" wrote in message ... Hi RD - When I enter the INDEX formula it merges rows 1 & 2 in my "ALL" document. If I want all the info in row 6, columns b thru aq to *index* over to my "ALL" document in Column T rows, 2 thru 42, how would I adjust your formula? I guess I'm a little confused on this. Sorry! KED "RagDyer" wrote: You asked for instructions to *copy*, and that's what DannyS gave you. What you're describing here is actually looking to *link* cells, since you want changes in the original cells to be reflected in the "other" cells. This formula can be entered *anywhere*, and copied down as needed: =INDEX(RN!$6:$6,ROWS($1:2)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ked" wrote in message ... Hi Danny: I tried this however it doesn't completely work for me, because I notice when I change a date in the original sheet RN it doesn't copy into the sheet ALL that I copied to. Any suggestions? "DannyS" wrote: Copy your rows, then click in the destination cell where you want to copy. Select Edit | Paste special. Tick the transpose box, then hit ok. "ked" wrote: I am trying to copy the data in row 6 in a spreadsheet - data range - b6:aq6 in worksheet RN to the destination of column T in worksheet ALL. I am not being successful in making it copy across - can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up information based on Columns and Rows | Excel Worksheet Functions | |||
| Hiding of rows and columns | Excel Discussion (Misc queries) | |||
| inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
| Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
Linear Mode
