Hi everyone,


I am having trouble trying to get my head around time stamping.

Currently i have a doucment template that i have built, and because of multiple users it will have some cells locked from editing to avoid errors.

The sheet is a project summary - As milestones are met with the projects the users can change the dropdown box values to match.

I wish to have a time stamp calculated from these dropdown box changes and entered into the blank cell below, but i am finding it very difficult.

Because this document will continue to grow as new projects are added to the list the solution must not be specific to any one cell (e.g. d12)

I initially wanted a non macro code that would run through the spreadsheet (so the users do not need to enable the macro each time), however it may be too complex which means it may require a macro.

These time stamps must not change when the spreadsheet is re-opened.


Can anyone point me in the right direction?

Project Milestone Summary - Draft 1.0.xlsx