View original (French)

[Google Sheets] Show cell modification date

Cmoi2025 -  
PapyLuc51 Posted messages 4569 Registration date   Status Member 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 answers

  1.
    PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
     
    Hello,

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

    Best regards
    1
  2. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
     
    Hello

    In B2 for A2

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

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

        Best regards
        0
    2. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
       
      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