If cell value = C then current time in another cell.

[AKENNA431]

Hello,

I'm trying to create a checklist. There is a drop down menu on one end of the checklist that allows you to choose "C" to mark a particular item complete. I want the spread sheet to log the time each individual checklist item is complete. Currently I have in the cell that needs to show the time =IF(A5="C",NOW()," ") ...my intent here was if A5 is C then itll pop up with the current time in the cell showing that formula (G6.)...that formula works until you go down to the next checklist step and put a C in it's status block. It also puts the current time in its corresponding 'time complete' box but it also updates all other 'time complete' cells with the current time, instead of showing the time that they were completed. Is there a better way to approach this, either with formulas or Macros? Thanks.

AJ

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

actually, I can see the logic in that code you just provided, and if I change the checklist up to match your logic then it works perfectly. So that's what I'm going to do. Thanks a lot for your help!