Hi All
I'm new to this so apologies if I don't follow protocol.

I am a basic excel user and want to use a spreadsheet to track progress of work through a series of activities in a process.
This will be used by a number of team members. So I would like to keep the recording simple by the use of a drop down to set the status of the work and date stamp a column relating to that status when that status changes, so you end up with a series of columns representing steps in the process with dates they were undertaken. This is done simply by team members just changing the status column. I have tried simple if formulas but as you would expect when the status changes the previous date changes.

I have no experience of macro's. Any help would be appreciated.