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
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
If you just need the data in column A........
Select B2:AJ2 and copy.
Select A2 and Paste Special>Transpose>OK>Esc
Gord Dibben Excel MVP
On Wed, 7 Dec 2005 17:18:55 -0600, "Fred Smith" <[email protected]> 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?
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" <[email protected]> wrote in message
news:%23%23apJR4%[email protected]...
> 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
>
>
>
Thanks Ragdyer. It was the formula I needed, as I want the destination changed
whenever I update the source.
Fred.
--
Regards,
Fred
"Ragdyer" <[email protected]> wrote in message
news:%235tnhn6%[email protected]...
> 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" <[email protected]> wrote in message
> news:%23%23apJR4%[email protected]...
>> 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
>>
>>
>>
>
Thanks for the feed-back.
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
"Fred Smith" <[email protected]> wrote in message
news:%[email protected]...
Thanks Ragdyer. It was the formula I needed, as I want the destination
changed
whenever I update the source.
Fred.
--
Regards,
Fred
"Ragdyer" <[email protected]> wrote in message
news:%235tnhn6%[email protected]...
> 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" <[email protected]> wrote in message
> news:%23%23apJR4%[email protected]...
>> 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
>>
>>
>>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks