Quote:
Originally Posted by RB[_2_]
I have a model that uses three variables to give the final result. Each of these variables can be changed and the final result will also change. I want to record the value of the final result each time I make a change to the variable. How can I record that changing value?
|
You could use an Event Macro.
The macro could be triggered each time one of the input cells is updated. The macro would then record the result in a separate worksheet.