If two columns don't match, date stamp a 3 column

  • Hello there,


    Forgive my ignorance, it's been many a year since I have been working with VBA.
    I'm currently trying to get a function working where there should be matching cells in two different columns on the same row, but if there is no match then apply a date stamp in a 3rd column.
    I can get the date stamp to work but only if 1 column changes and doesn't match - but what I am trying to achieve is if either of the two columns change and don't match - apply a date stamp and If they do match, remove the date stamp and finally if one of the cells is blank; remove or don't apply a date stamp.





    Any advice would highly be appreciated,


    Cheers,
    Kevin

  • Re: If two columns don't match, date stamp a 3 column


    Hi Kevin, and welcome to the forum! :)


    I think this will do what you ask.

  • Re: If two columns don't match, date stamp a 3 column


    Kevin,


    Glad to hear. Come back any time, we're all students at different levels.


    Cheers!

Participate now!

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