Hi all. I was hoping I could get some help with VBA code.
I would like one particular cell (I5) to have contents cleared with one of either of the following two trigger words selected in another column (M4:M53). The trigger words are "NOON in PORT" or "NOON in TRANS".

Also, to make things clear, the trigger words have to be the last value in the mentioned column range. For example, if M25 has "NOON in PORT" selected it will clear I5. The spreadsheet is being copied new, renamed with present date and being updated on a daily basis. So if the next day M26 has "NOON at SEA" I5 will not be cleared and ignore "NOON in PORT" from the day before, and so on. Thanks for any help.