I'm trying to create a VBA code to do goal seek every time the some changes created on the input values (Automatically).
Can any body help me step by step on how to do it?
I have well data and there is a cell "M12" with the guess value, cell "M13" with calculated value and cell "M14" with the difference between M13 and M12. I don't want to apply goal seek manually every time I change the guess value.
I would really appreciate it !
Can any body help me step by step on how to do it?
I have well data and there is a cell "M12" with the guess value, cell "M13" with calculated value and cell "M14" with the difference between M13 and M12. I don't want to apply goal seek manually every time I change the guess value.
I would really appreciate it !