How can I copy a formula where the referenced cells have an assoc.

[Guest]

I want to copy a formula where the cells have an associated range name but
all I get is a repeat of the original formula. I want to have formulas where
the cell references change as the formula is copied.

 

[Gord Dibben]

That is the purpose of Named Ranges.

They do not change. They are not relative.

Say Namedrange is A1

=Namedrange * B1 will change to =Namedrange * B2 if copied down column C, but
Namedrange will remain the value in A1.

On another note.......if your cellsrefs like B1 are not changing to B2, B3
etc. perhaps you have Calculation on Manual mode.

Check Tools>Options>Calculation.

Gord Dibben Excel MVP

 

[Guest]

Well, not exactly. Named ranges can be relative also.

If you create a name like this:

CellAbove="Sheet1!R[-1]C"

rather than

MonthlyData="Sheet1!R9C2:R20C2"

then as you copy around a formula with "CellAbove" in it it will remain
relative.

(Oh, please don't use A1. It sucks. R1C1 is so much better.)

James.