Copy and Pasting Formulas are incrementing
Thank you that solved the issue. I just never knew much about the formulas.
its been awhile
"RonaldoOneNil" wrote:
Your original formula needs to have an absolute reference to stop it changing
as you paste into another column
i.e. $A$1 instead of just A1
"anickless" wrote:
Hi i am trying to paste formulas from one column to another, however when I
do a paste - special - formulas it seems in increment the cell references
with the formulas
e.g the correct formula would be A1
but when I paste formulas it comes up as B1
what is going on here?
|