Capturing date changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Work - 16 Mar 2007 01:35 GMT

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

Reply to this Message

tylagusim@hotmail.com - 16 Mar 2007 05:12 GMT

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 /

> Hi
>
[quoted text clipped - 9 lines]
>
> I could use your help thanks

Reply to this Message