| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formula without changing the row.
How do I copy a formula ('PR Detail'!D$14/2) to another cell that the column changes but not the row. I thought this would work. The above formula is copied down to the next cell, but the column doesn't change. Probably because the PR Detail worksheet is going across columns? Any tips to make this work? Would appreciate your suggestions. VWyatt :) -- vwyatt ------------------------------------------------------------------------ vwyatt's Profile: http://www.excelforum.com/member.php...o&userid=33048 View this thread: http://www.excelforum.com/showthread...hreadid=528638 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy formula without changing the row.
Hi!
What do want to happen? Are you wanting to drag copy the formula down a column such that the column reference increments? Like this: ='PR Detail'!D$14/2 ='PR Detail'!E$14/2 ='PR Detail'!F$14/2 ='PR Detail'!G$14/2 etc Biff "vwyatt" wrote in message ... How do I copy a formula ('PR Detail'!D$14/2) to another cell that the column changes but not the row. I thought this would work. The above formula is copied down to the next cell, but the column doesn't change. Probably because the PR Detail worksheet is going across columns? Any tips to make this work? Would appreciate your suggestions. VWyatt :) -- vwyatt ------------------------------------------------------------------------ vwyatt's Profile: http://www.excelforum.com/member.php...o&userid=33048 View this thread: http://www.excelforum.com/showthread...hreadid=528638 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy formula without changing the row.
Yes. The column reference should change but not the row. -- vwyatt ------------------------------------------------------------------------ vwyatt's Profile: http://www.excelforum.com/member.php...o&userid=33048 View this thread: http://www.excelforum.com/showthread...hreadid=528638 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Formula That References Another Sheet | Excel Discussion (Misc queries) | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| How do I copy a formula with relative ref. keeping the same ref.? | Excel Discussion (Misc queries) | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Linear Mode
