I'd like to have an Excel 2007 forumla that picks up the formula from another
cell so that I can just change it in one and have it automatically update all
the others:

eg. =formula($b$2)

The formula being picked up would have absolute and relative references,
lookups etc.

This would save an awful lot of work.
Ideas?

Thanks!

Just use a link. If the formula in B3 is

=A1+A2

The in another cell enter:
=B3

the new cell will display the result of the same formula that B3 contains.
(ther value appearing in the new cell will be the same as the value in B3)

If you change the formula in B3, the result in the new cell will reflect the
new formula.
--
Gary''s Student - gsnu200859


"jjaylad" wrote:

I'd like to have an Excel 2007 forumla that picks up the formula from another
cell so that I can just change it in one and have it automatically update all
the others:

eg. =formula($b$2)

The formula being picked up would have absolute and relative references,
lookups etc.

This would save an awful lot of work.
Ideas?

Thanks!