Using conditions to replace the value of a cell just modified [VBA]

  • Hi, so what I've been trying to do without success is to make excell automatically replace the content of a cell if it's in column "B" and its value has just been changed to "Distribute".
    Then, if the content of the cell in the same row but in column E is empty the value to replace "Distribute" will be copied from cell M22 in another worksheet.
    Or, If the content of the cell in the same row but in column E is NOT empty the value to replace "Distribute" will be copied from cell M24 in another worksheet.


    How should I proceed to make it happen?
    Thanks in advance!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!