Prev: background colour of sheet gone gray need to change to whit
Next: 11 months and 1 day from a given date
From: RRG on 22 Apr 2010 18:35
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?
From: Fred Smith on 22 Apr 2010 18:40
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" <RRG(a)discussions.microsoft.com> wrote in message
news:59164535-29A5-4C3B-ABDF-5C8733AAAEC6(a)microsoft.com...
> 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?

From: Max on 22 Apr 2010 19:08
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?
From: Gord Dibben on 22 Apr 2010 19:12
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 <RRG(a)discussions.microsoft.com>
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?

 | 
Pages: 1
Prev: background colour of sheet gone gray need to change to whit
Next: 11 months and 1 day from a given date