Yeah, aware of absolute references, but the problem is that a lot of dragging
and forumla copying was needed in Sheet 1 and hence I never set the formulae
up as absolute...

"FSt1" wrote:

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€¦