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

Excel VBA 1
Excel Help to copy information from one row at a time to another sheet 1
formula drag down/copy changing integers of 6 2
copy/paste row with one formula 6
copying formulas and changing cell references 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
current row in formula 3
Formula Quesion 5

Top