Is there a way to get a cell to basically do the same formula as a preceding
cell, so that when the preceding cell's formula is updated, the dependent
cell does the same formula? In other words, if I have a sum formula in 12
columns, and I modify one of them, I currently have to select all the cells
and update the formula in each (even if we're talking about ctrl-enter to put
the same formula at once). But is there any way that the 11 cells other than
the first one can be written to basically, on their own, do a different
calculation when I alter that first cell's formula? If there are 12 columns,
it's obviously easy. But when you have a very long sheet and maybe have
similar formulas in different places, selecting them all before changing and
ctrl-entering is annoying. Just not sure if someone else has come up with a
way to do this and I am missing out on an efficient way of updating formulas.

Thx.

--
Boris