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!