"Timestamp"

[Js1976]

I'm trying to figure out a code to be able to put an "X" in a group of cells and have a timestamp display in in another cell. Is this possible? I've attached the document that I'm working with so you can see what I'm doing.

[Tsjallie]

You can try this formula in the Timestamp column:

Please Login or Register  to view this content.

Timestamp always reflects the time the last "X" was entered.

[Js1976]

It worked perfectly!!!! Thank you very much!

[Js1976]

Ok, The formula did what I need it to, the only problem is that it updates each timestamp. How do I make it so that the only change is in the row that is being modified?

[Js1976]

Ok, the program worked for what I asked for. Thank you for that; but now, it's updating all the timestamps and I need it to update only the row that is being modified.

[Tsjallie]

The formula should only set the timestamp in one row, because it counts the number of x's in the same row the formula is in.
If it apparently is effected by other rows you should check if references only the current row.
E.g countiff(B10:I11,"x") will count the number of x's in row 10 and 11. Maybe something like this happens.
You may also upload your sheet (or a relevant part of it) so I can have a look at it.

[Js1976]

Digital Logs.xlsx

Here is the log sheet with the new formula entered.

[Tsjallie]

OK. The problem is in the NOW() function. That's updated each time the sheet is recalculated.
Sorry for overlooking that, but can be solved pretty easily. I'm going in ameeting now. Get back to you asap.

[Tsjallie]

Here's the altered sheet.
Discarded the formula and replaced with a small piece of code in de worksheet_change() section.
You can access that code thru the VBE.

The code handles changes in the cells where you put the x's. If you put in an x in some cell it puts a timestamp in the corresponding timestamp column.
If you delete an x it will remove the timestamp only when no other x's are remaining.

[Js1976]

Thank you SOO MUCH! It works perfectly!

[Tsjallie]

Glad I could help.
If you need any further assistance pls let me know.
If your problem is solved don't forget to mark this thread as [SOLVED].
If you appreciate my help pls add to me rep by clicking the * below my post. Thank you.