auto-datestamp in cell based upon value in adjacent cell

Hi All,

I hope there's a genius out there who can help me with this - I have an excel workbook which records the progress of work within my team. Don't agree that excel is the right tool for the job, but am stuck with it for the time being as our company is phobic of trying new things!!!

My issue is that when a project is classed as at a specific stage my boss wants to record the date / time that the project status was updated.

So, for example. Project is classes as "7 Commercials Issued" in Column K. Column N should record the date/time (or just date if date and time is not possible).

Column K has Validation in it so there is always a value in it from the following list:

0 Awaiting Review
1 CID - Customer Initiation Document
2 Customer Presentation / Workshop
3 BRD in progress
4 Technical Requirements Doc in Progress
5 Solution Document In Progress
6 Commercials in Progress
7 Commercials Issued
8 On Hold
9 Signed / Commercials approved
10 Descoped
11 NFA required

What we are interested in is recording the date that Commercials are issued - i.e. when the K2 cell was modified to contain "7 Commercials Issued".


I am tripping up all over the place with the TODAY() and NOW() functions (as these will always refresh on opening the work book and have never ever used VB

Any help from one of you guys would be really appreciated!!!
I have seen similar posts with responses that have worked for the requestor in the end but when I try and copy / Paste and modify to suit my needs it never works and I am at a loss as to what I am doing wrong!

Many Many thanks in advance,

Kirsty

thank you, but I have spent all morning looking at this page (havingreviewed many similar threads on here) and I just don't get it.....

Hi there - thanks for taking the time...

In the attached, I am looking to autopopulate the date/time into Column N when Column K is modified to read & Commercials Issued.

Thanks so much in advance for your time on this..

Attachment 226465

Hope this works... what an idiot!

Thank you SOOOOOOOOOOOOOOOOOOOOOOOOOOO Much!!!!!!!!

I can't tell you how much I appreciate this - just hope that the colleagues I share this workbook with don't mess with the formula!

Very Best Regards,

Kirsty

P.S. My Daughter is named Athena, after your beautiful City - we visited there the summer before she was born!