I have sheet with data in Cells C2 to E14.
If anything is changed in Col E, I have VBA code that will input today's date into a cell (C10), which happens to be next to a cell with entry of Report Date.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 Then
Application.EnableEvents = False
Cells(10, 3).Value = Now()
Application.EnableEvents = True
End If
End Sub
What I want to do is change the code to add Now() next to the cell with value/entry of Report Date instead of specifying Cells(10,3)
The cell with entry of Report Date happens to be B10. But in another sheet, that same entry may be B13.
How would I do this? What would that code look like?
Thanks for any assistance given.
Bookmarks