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

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

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