Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
Ragdyer
 
Posts: n/a
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default 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






  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR
 
Posts: n/a
Default 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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 06:18 PM
Generate a graphical formula from a column of data rmellison Excel Discussion (Misc queries) 2 October 17th 05 03:58 PM
how to put data in the column A to the next row of the column B jims Excel Discussion (Misc queries) 1 August 5th 05 12:44 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Howdo U copy a formula down a column, that uses data in another w. Need Help pasting a formula Excel Worksheet Functions 1 February 25th 05 07:04 PM


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"