Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Generate a graphical formula from a column of data | Excel Discussion (Misc queries) | |||
how to put data in the column A to the next row of the column B | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions |