If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying Cells with Fill Handle
Can anyone help? I am trying to copy cells across a row using the fill handle
that are referencing another sheet down a column. I am placing a "$" in front of the letter as to not change it, but since I am copying across, the number will not change. Is there any way to tell Excel that i want the number to advance as I copy across? |
#2
|
|||
|
|||
Copying Cells with Fill Handle
If you want "the number" to advance as you copy across, then don't put a $
in front of it, as in: =$A1*2 Regards, Fred "RRG" wrote in message ... Can anyone help? I am trying to copy cells across a row using the fill handle that are referencing another sheet down a column. I am placing a "$" in front of the letter as to not change it, but since I am copying across, the number will not change. Is there any way to tell Excel that i want the number to advance as I copy across? |
#3
|
|||
|
|||
Copying Cells with Fill Handle
What you seek is to transpose contents from a source col into a destination row
One way, in say Sheet1, in B2: =INDEX(Sheet2!$A:$A,COLUMNS($A:A)) Copy B2 across as far as required. This links/returns the contents of Sheet2's A1, A2, A3, etc in Sheet1's B2, B3, B4, etc. Joy? hit the YES below -- Max Singapore --- "RRG" wrote: Can anyone help? I am trying to copy cells across a row using the fill handle that are referencing another sheet down a column. I am placing a "$" in front of the letter as to not change it, but since I am copying across, the number will not change. Is there any way to tell Excel that i want the number to advance as I copy across? |
#4
|
|||
|
|||
Copying Cells with Fill Handle
Let's say in Sheet2 column A you have numbers 1 to 10 in A1:A10
You want them in Sheet1 from A1 to J1 Enter =INDIRECT("Sheet2!A"&COLUMN(A1)) in A1 and drag across. Gord Dibben MS Excel MVP On Thu, 22 Apr 2010 15:35:01 -0700, RRG wrote: Can anyone help? I am trying to copy cells across a row using the fill handle that are referencing another sheet down a column. I am placing a "$" in front of the letter as to not change it, but since I am copying across, the number will not change. Is there any way to tell Excel that i want the number to advance as I copy across? |
Thread Tools | |
Display Modes | |
|
|