View original (French)

[Google Sheets] Show cell modification date

Cmoi2025 -  
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   -
Hello

I need to display the modification date of hundreds of cells in a column in the right column next to each relevant cell.
Is there a function that shows the modification date (and time if possible) of the cell on the left?

Thank you in advance.

2 réponses

Réponse 1 / 2
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 509
 
Hello,

See the response I made >>>> HERE <<<<

Best regards
1
Réponse 2 / 2
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 509
 
Hello

In B2 for A2

=IF(A2<>"",NOW(),"")

Best regards
0
Cmoi2025
 
Hello
It's a lead, but the date keeps changing
I'm looking to display the modification date of the cell
0
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 509 > Cmoi2025
 
Yes indeed, I think we'll need to go through VBA; so I'll leave you in expert hands.

Best regards
0
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 509
 
Hello,

In fact, regarding VBA, it's more about the JAVA language on Google Sheets.

While searching online, I found this VBA code that works very well on Excel; the date and time only change if you modify the cell to the left. Since I have no knowledge of English, I don’t understand what it means other than selecting the source column. 

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A:A")) Is Nothing Then
Target.Offset(0, 1) = Now
End If
End Sub


There’s certainly someone who can translate this into language for Sheets.

Best regards.
0