Hi, 

I’ve seen a few similar posts but can’t quite find what I’m looking for, hopefully someone can help. 

I’m looking for a macro that will change a value from ‘Y’ to ‘N’ when a date change occurs in the previous column, for example as below. If a date change occurs in column C, the value in column D changes to ‘N’ (column C pulls the date from another location using an XLOOKUP, and I want to be alerted if there is a change date). 

Any help would be much appreciated, thanks in advance

​Hi,  I’ve seen a few similar posts but can’t quite find what I’m looking for, hopefully someone can help. I’m looking for a macro that will change a value from ‘Y’ to ‘N’ when a date change occurs in the previous column, for example as below. If a date change occurs in column C, the value in column D changes to ‘N’ (column C pulls the date from another location using an XLOOKUP, and I want to be alerted if there is a change date).  Any help would be much appreciated, thanks in advance    Read More

​