I've been dealing with how to run a macro when certain cells change in Excel: I mean, under certain conditions a human being could manually change a value in a cell, and then, this change should trigger a recalculation in another cell. I'd like to precise that in my workbook, for internal reasons, it is no possible to use formulas.
Anyway, up to a certain point, the support Microsoft is clear.
In particular, if I know in advance the range that has to cause a recalculation, no problem:
Set KeyCells = Range("A1:C10")
Now, my task is harder.
Suppose I've a blank sheet with just a button to run a macro (see attachment "Recalculate-1").
Before running the macro "Update", i don't know what will be the result in terms of populated area.
Suppose, after the running, the new situation as in the second attachment ("Recalculate-2).
I need the green cells triggering recalculation, identified as follows:
- for each value "6" on column B, the green cells have to be - in the same row - from column D to the last populated column in the sheet (in this case, F);
- in event of inserting manually a new value in the green cells, recalculate the sum in column C of the same row (so, suppose I change manually the value in cell E19 from 150 to 100, then the new value in C19 will be 400).
Could anyone help me?