i would like to write a view code that if someone edits a formula in column
AC, the macro copies that formula to 3 different cells on that line.

assumptios:
column AC is called "tot_dollars"
currently cell AC10= ac11+ac12.
lets say the user edits this formula to ac10=ac11+ac13.
i want the macro to automatically recognize that the user modified the
formula and to copy/pastespecial/formulas that new formula to three different
cells on that line (ad10, bb10 and cc10)

help?

I did start with this sentence but ran into trouble when i deleted a row as
it triggered the event. technically i didn't enter or modify anything in
"Tot dollars" but by deleting it it considers it an event?
If Intersect(Target, Range("tot_dollars")) Is Nothing Then exit sub

thanks in advanace,
Tami