Date Stamp in a single cell when several columns change

Hi everyone,

To provide some context for my issue, I'm creating a project coordination spreadsheet meant to keep track of progress on proposals from start to finish. In order to ensure that proposals aren't simply abandoned when things are getting busy with other projects, I got to work building a code that would keep track of when items within different columns were updated and create a time stamp in another column of what was updated in that specific row. However this was not what I was aiming to accomplish. My goal was to have whatever was updated in these columns would return an updated date and time in a single cell, not every cell in the column adjacent. So whenever the sheet is updated, the time/date of said update is recorded in a single cell on the same sheet. Is there a way to make this possible? I'm very new to VBA coding and would like some assistance. You can find my current code (and password coding) below to help you understand what I'm working with.

Private Sub Worksheet_Change(ByVal Target As Range)
  
  Dim pswStr As String
    pswStr = "Password!"
    On Error Resume Next
   Application.ScreenUpdating = False
    ActiveSheet.Unprotect Password:=pswStr


  
  Const ColumnsToMonitor As String = "L:Q"
  Const DateColumn As String = "R"
  Application.EnableEvents = False
  If Not Intersect(Target, Columns(ColumnsToMonitor)) Is Nothing Then
    Intersect(Target.EntireRow, Columns(DateColumn)).Value = Now
  End If
  Application.EnableEvents = True
  
   ActiveSheet.Protect Password:=pswStr
End Sub

Thanks,

- T

Thanks for your input all,

To clarify, I want each sheet to display the last time that sheet was edited in a single cell. Also, this will be a shared workbook, so others will be adding to it over time.

[ATTACH=JSON]{"alt":"Click image for larger version Name:\t2.PNG Views:\t0 Size:\t41.0 KB ID:\t1225604","data-align":"none","data-attachmentid":"1225604","data-size":"full"}[/ATTACH]

The image above shows the spreadsheet I'm dealing with. Currently I have a box next to the grayed section to record any changes on each row. It would be helpful if whenever any changes occur in the grey space, a single cell would record the last time an edit was made. I don't need to keep the records of past edits, just a display of the most recent edit, as the goal is to ensure that proposal managers are continuing to work on proposals to completion and to keep track of ongoing proposals. I can't rely on people pressing the button when they are done editing (laziness/procrastination/rushing always being an issue). I have tried the track changes option, but since I was aiming to combine it with conditional formatting (say when the date recorded is more than 30 days from today's date, the cell would highlight) this wouldn't entirely work. Hopefully this clarifies things.

Thanks,

- T

This modification doesn't change anything I'm afraid. When a given row changes, it generates a time stamp in a cell on the same row, rather than update a specific cell if any of the rows are changed. Thanks everyone for their input, I understand this isn't the easiest problem to fix.

It didn't I'm afraid. Maybe this will clarify things better. What I'm looking for is that whenever a cell within the Range A2 to E20 are changed, the cell in A1 records the current time the last edit took place.

It works! Thanks so much! I have to present this spreadsheet at a big meeting tomorrow so this has been a life saver!