Hello,
I have a workbook where I track projects. Whenever I enter an update in the comments section for a particular project I enter the current date and the word UPDATE! into a column labelled Updated. The format should look like the following.
18-Aug-08
UPDATED!
As I have to do this on a regular basis I wanted to create a macro that would do this. I came up with the following.
It works great except that any cell that I run this macro against will see the date change every day as I used TODAY() in my formula.
Is there a way that I can change this so that after I run the macro and the date is entered that it doesn't change until the next time it's run?
Thanks and regards,
Chris
Bookmarks