rtour957 wrote:

Searching the forum I found the code to date stamp the comment but what
I need is a bit different and unfortunately more complicated.
Say I have validation drop down menu in Coumn A, Column C and Column E
to choose from: Sent, Received, Returned, Processed. There are about 6
different users who use this spreadsheet and I need a user specific and
action specific date stamp as many time as the values in A, C,and E are
changed - to be tracked and displayed preferably in the comment. If not,
then a separate table might work. There are about 80 rows of data.

I'm not sure what "comment" you mean, but I'm going to assume you want some
sort of logging. Have a look at the logging code I posted last year, in the
thread called "Macro to create log file". The current version of the code can
be downloaded he

http://auric.altervista.org/excel/track_changes.bas

The code in that file needs to go into the ThisWorkbook class of the workbook
being tracked. It's in the public domain so feel free to change it as you
desire... if it does what you need it to, that is. (It tracks *everything*,
not just 3 columns.)

--
Courage of the heart is very rare.