It seems that the way to do this is with a macro. I wrote the macro to run
the solver on the cells I want to update. How do I tie the macro to run
automatically whenever the target cell changes value?
For instance, if cell A1 not equal zero, run macro 2 otherwise do nothing.

Thanks

"Mike Middleton" wrote:

Brian Hahn -

If you want to see some previous discussions of this topic, browse to
groups.google.com, and search for "excel goal seek automate" (without the
quotes).

- Mike

"Brian Hahn" wrote in message
...
Is there a way to automate the goal seek or solver functionality?
For instance, automatically set a target cell to zero by changing another
cell.