Copy & Paste Forumla - but reference cell is changing
hi
in xl help, look up absolute references vs. relative references.
Relative references varies depending on where you paste them.
aboslute references do not vary.
to make a relative reference absolute, put dollar signs in from fo the
column and row reference i.e. instend of A1, put $A$1.
regards
FSt1
"Andy" wrote:
I am trying to copy and paste a large section of one worksheet into another
but the reference cell in the formula keeps changing. How can I paste it so
that the reference cell remains the same regardless of where I paste it?
i.e. Cell B15 in Sheet 1 has the formula
=IF(model!AA25<"",model!AA25,model!Z25). When I paste this into cell C8 in
Sheet 2, the formula changes to =IF(model!AB18<"",model!AB18,model!AA18)
but I want it to still reference model!AA25¦
|