Running A 'Goal Seek' on evnet for specfic cells (range)

[jxb]

To all

I have written a simple macro which loops through a range of cell and executes a goal seek (so I do have to do it manually!)
Any change to the values in the cells in that range (the 'Set cell' range) is flagged to the user and he must re-run the macro (the set cell must always be =1.0)

I realised that maybe a "on event" might be better because the data would always be up-to-date
Questions are:
1. Can a "on event" macro be created so that if that the value in the "input range" changes the goal seek is automatically re-run
2. Can the "on event" deal with a range of cells? (see test case explanation below)

I have attached an xls with a "test case"
The test problem is as follows
Column A: user input -
Column B: some intermediate process based on the user input
Column C: The change cell for the goal seek
Column D: the goal seek equation (= Set Cell) (To Value =1)

Scope:
If the value in range A2:A5 change (the on event) then run the goal seek for the appropriate row

any inputs/pointers, etc would be greatly appreciated

Regards

JXB

 

[jxb]

solved!