copy formula without changing the row.

V

vwyatt

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 :)
 
B

Biff

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
 
Top