HELP - Creating a Log of changes

Im almost a newbe! in vba

Log a previous cell value and the current value when a change has occurred in a range.

The Log entry shall be inserted on row 50 with a new row.

So what is some of what is needed to be plotted down:

current date and time,
what cell,
earlier value,
current - the value that has been changed to.

This is one of 5 ranges that need to be monitored, this how far i have come..
In the example below is col AP different responsibility areas
and AO is who are the person that are in-charge.

Please Login or Register  to view this content.

Hope that some knows how or can give me directions or hints how it can be solved or partly done.

Sincerely
Magnus

Use the Worksheet's "SelectionChange" event to capture the 'old' value.
Then use the Worksheet's "Change" event to capture the 'new' value.

For example:

Please Login or Register  to view this content.

Many Thanks to the solution you gave me.
Now I've learned even more


Here is what i have come up with.

Please Login or Register  to view this content.

Is there any optimization that can be done - in order to:
make it faster,
slim it down,
make it less severe on CPU..

Sincerely
Magnus