| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set up a copy and paste formula with ascending columns
I am pulling info from one sheet to another. I need to copy a formula going
vertically down, but I need the column designator to ascend and not the row. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I set up a copy and paste formula with ascending columns
Hi Ken
One way Supposing you have data in cells A1:E1 on Sheet2 and you want to copy the data to cells A1:A5 of Sheet1 In cell A1 of Sheet1 =OFFSET(Sheet2!$A$1,0,ROW(1:1)-1) and copy down. -- Regards Roger Govier "Ken Proj mgr" wrote in message ... I am pulling info from one sheet to another. I need to copy a formula going vertically down, but I need the column designator to ascend and not the row. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I set up a copy and paste formula with ascending columns
Just to clarify what you are looking for: You are looking to have a formula that in Row 1 =Sheet2!A1 Row 2 =Sheet2!B1 Row 3 =Sheet2!C1 -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=516282 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I set up a copy and paste formula with ascending column
Yes. I am putting the info into a column and I am pulling it from a row.
Ken "kraljb" wrote: Just to clarify what you are looking for: You are looking to have a formula that in Row 1 =Sheet2!A1 Row 2 =Sheet2!B1 Row 3 =Sheet2!C1 -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=516282 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I set up a copy and paste formula with ascending column
Roger,
I got it to work. Thanks for the help. I am preping 70 schedule sheets for various sub to build homes and this formula will save me a week worth of typing. You sir are the man. Ken "Roger Govier" wrote: Hi Ken One way Supposing you have data in cells A1:E1 on Sheet2 and you want to copy the data to cells A1:A5 of Sheet1 In cell A1 of Sheet1 =OFFSET(Sheet2!$A$1,0,ROW(1:1)-1) and copy down. -- Regards Roger Govier "Ken Proj mgr" wrote in message ... I am pulling info from one sheet to another. I need to copy a formula going vertically down, but I need the column designator to ascend and not the row. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert formula to its value w/out copy and paste | Excel Discussion (Misc queries) | |||
| why cant I copy and paste a formula? | Excel Discussion (Misc queries) | |||
| How can I copy and paste the text of a formula? | Excel Worksheet Functions | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
| Why can't a copy and paste columns? | Excel Worksheet Functions | |||
Linear Mode
