Capturing date changes

W

Work

Hi

I have an excel spreadsheet let me set up this example:
Column A Column B
Client Name Date Called
ABC
XYZ

Situation if I call ABC on 5/16/89 but I change the date the next day to
6/16/90 I need to maintain in another sheet all of the dates I contacted ABC
for purposes of reporting.

I could use your help thanks
 
T

tylagusim

One approach -- though awkward and CPU-intensive -- would be to tie
into the Worksheet_Change() event. You could use the 'Target'
parameter to determine if the change was in the column (and/or row)
you're interested in and, if so, copy things to another sheet. Note
you'd always be copying over the new value(s) that just got put in, or
changed, not the pre-existing values. (No functional difference here,
but possibly a conceptual one).
HTH

/ Tyla /
 
Top