Data row wise, formula column wise
 

I have data in cells b2:aj2

I want to refer to these cells in a column from a2 down. I can manually type in:

A2: =B2
A3: =C2
A4: =D2

Rather than doing so, is there a formula I can type in once in A2 then copy
down?

--
Regards,
Fred

Data row wise, formula column wise
 

If you just need the data in column A........

Select B2:AJ2 and copy.

Select A2 and Paste SpecialTransposeOKEsc


Gord Dibben Excel MVP

On Wed, 7 Dec 2005 17:18:55 -0600, "Fred Smith" wrote:

I have data in cells b2:aj2

I want to refer to these cells in a column from a2 down. I can manually type in:

A2: =B2
A3: =C2
A4: =D2

Rather than doing so, is there a formula I can type in once in A2 then copy
down?

Data row wise, formula column wise
 

Since you DID ask for a formula to copy down, here's one to try:

=INDEX($B$2:$AJ$2,ROWS($2:2))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Fred Smith" wrote in message
...
I have data in cells b2:aj2

I want to refer to these cells in a column from a2 down. I can manually
type in:

A2: =B2
A3: =C2
A4: =D2

Rather than doing so, is there a formula I can type in once in A2 then
copy
down?

--
Regards,
Fred

Data row wise, formula column wise
 

Thanks Ragdyer. It was the formula I needed, as I want the destination changed
whenever I update the source.

Fred.

--
Regards,
Fred


"Ragdyer" wrote in message
...
Since you DID ask for a formula to copy down, here's one to try:

=INDEX($B$2:$AJ$2,ROWS($2:2))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Fred Smith" wrote in message
...
I have data in cells b2:aj2

I want to refer to these cells in a column from a2 down. I can manually
type in:

A2: =B2
A3: =C2
A4: =D2

Rather than doing so, is there a formula I can type in once in A2 then
copy
down?

--
Regards,
Fred

Data row wise, formula column wise
 

Thanks for the feed-back.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Fred Smith" wrote in message
...
Thanks Ragdyer. It was the formula I needed, as I want the destination
changed
whenever I update the source.

Fred.

--
Regards,
Fred


"Ragdyer" wrote in message
...
Since you DID ask for a formula to copy down, here's one to try:

=INDEX($B$2:$AJ$2,ROWS($2:2))

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Fred Smith" wrote in message
...
I have data in cells b2:aj2

I want to refer to these cells in a column from a2 down. I can manually
type in:

A2: =B2
A3: =C2
A4: =D2

Rather than doing so, is there a formula I can type in once in A2 then
copy
down?

--
Regards,
Fred