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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Cumulative formula for word table 0
How do I insert a row without the formula changing? 1
Help with an Excel formula please? 7
Auto deletion of cell entry in given circumstance 0
Why cant I expand the equations parameters without error? 5
changing rows *and* columns in automatic formulae 1
Find values across a row and return a text value from the same column 3

Top