You would have to handle the
Worksheet.Change event (Excel)[
^], check the Range object you get to the cell that changed, make a decision on if your calculations and changes have to be made, then make that change.
That's about the only description you're going to get based on so little information in your question.