Run Macro on cell exit or change

[COPCV]

I have a Workbook with two worksheets: Clients; Client notes
The Client worksheet has multiple columns, but the two I’m interested in are: Name and Last Contact Date.
The Client Notes sheet has Name, Contact Date, and Note columns.
I’m looking for a macro that would run when the Last Contact Date on Clients worksheet is added or changed. I would like the Name and Last Contact Date copied from Clients to the Clients Notes worksheet.
Any help is appreciated!

[Arkadi]

This can be accomplished with a worksheet_change event. In VBA editor, if you double-click on the Clients worksheet, you will see pulldowns at the top. Change the one that says "General" to "Worksheet" and then change "SelectionChange" to "Change". With a copy of your book (only needs a small amount of sample data, but real layout) we can help further.

[COPCV]

Great.
Here's a sample

[Arkadi]

Ok so... go to vba editor (Alt-F11), double click the Client Sheet in the project browser, and paste in this code. You will want to format column B on Client Notes as date, or the copied data will end up as a date serial instead of the standard date format. Just highlight the whole column and format.

Please Login or Register  to view this content.

[COPCV]

Great!
Thanks so much.
If I wanted the cursor to come to rest in C on ws Client Notes at end of the macro, what code do I add?

[Arkadi]

after the End If line (so just before End Sub) add,

Please Login or Register  to view this content.

[Arkadi]

COPCV,

If you are satisfied with everything now, please mark the post as solved? Thanks!