Tracking Date Changes
Lee
You could use a Worksheet_Change event macro that would "see" every
change made to that cell. That same macro could also "see" what the cell
contained before the change and place what you want in some hidden sheet
(date, time, amount of slip, etc). Is this something like what you want?
Post back if you need help setting this up. Include details about the
file/sheet setup and if there is more than one such cell you want to track.
HTH Otto
"Lee" wrote in message
...
I have a cell in which a user enters a completion date. I would like to be
able to track 1) the number of times the user changes the date in this
cell
and 2)by how much he changes the date each time and keep a history of this
(ex 20 day slip, 30 day slip etc.)
Is there a way to do this in Excel?
Thanks in advance.
|