For every row when cell C<whatever is updated I need coresponding cell
D<whatever to update with a date time stamp until such a time that
particular cell C is updated again. Been all over the place looking at macros
worksheet functions etc. and nothing quite matches what I need. Currently I
am using Ctrl-Shift-; followed by Ctrl-; to quickly enter this, but there has
to be a way where I do not have to enter it all.

Thanks in advance