Hello,
With the help of the people from this forum, we arrived at the bellow code, now I faced a different challenge I would like the code to log the change of the cell, like is doing with the bellow code just in case of a specific change (example in column 4 I choose from drop-down list NO, YES, MAYBE ) the VBA should not count them as a change, but any other value should be counted towards the changes counter.
Any idea or hint will be welcomed.
P.S Big thx to the people that helped me last time.