Hello,

I have started to work more with excel again in my new job and require
some help on a tracker spreadsheet that has been created. Best way is
to use an example of what I am trying to achieve.

Suppose we have 4 columns

Col A - ID
Col B - Version
Col C - Project Name
Col D - Received On
Col E - Agreed Delivery Date
Col E - Delivered Date
Col F - Status

I want to try and implement a History log on Column F - Status. The
status changes depending on projects and the status is to be updated
as we go along.

Currently new comments overwrite old comments within the Status
Columns Cells. I would like that once a cell has been updated, e.g

Cell F2 was - Build started. THEN on another day
Cell F2 changes to Build delayed.

The old comments should be saved on a separate sheet with the ID,
Version, Project Name and the Old Comments with a date when it was
changed.

I would be grateful if someone pointed me to the right direction to
carry this solution out otherwise it leaves me with a manual editing
option which is time consuming.

Appreciate your help on this.

Thanks

Sp