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

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 /



On Mar 15, 4:35 pm, "Work" <RFrai...@verizon.net> wrote:
> 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