Hello all,
I have a workbook that syncs a list of tasks bi-directionally with Outlook Tasks, and that's working just fine.
I also have a macro that creates a static times tamp every time the "Status" column (Column D) changes.
The problem is, every time I open the worksheet and it syncs with Outlook, it refreshes Coulmn D and the time stamp changes even if the text has remained the same (no status change).
Below is the macro I'm using to create the time stamp: is there a way to modify so it only time stamps when the actual text in the cell (Column D) changes and not just when the workbook syncs and refreshes column D with the same data?
Thank you so much!!!
Bookmarks