Hiding rows after cell entry

[XrayLemi]

Hello everyone. Hope you are all well and safe.

Here is my dilemma. I need to hide rows after a value is entered. All the code I have seen posted here will hide every row after a cell entry is made. What I need is, if I add a date in column "E" next to the name Bill like in the picture, I want every row with the name Bill in column "D" to be hidden EXCEPT the row with the date. Later if I add a date in column "E" next to the name Gus, all the rows with Gus, except the row with the date, will be hidden. Once the date is added in column "E" that name will never be added to the list again. So, I won't have to worry about hiding future entries with that name.

The name here is generic. There will be first, last and maybe middle names as well. I don't know if it matters, but all the entries in columns A-D are auto filled by entries in other workbooks. the only manual entry is the date in column "E". Hope this

Thank you in advance,
Jim

 

[JoeMo]

Will the col E cells for a given name always be empty except for the one row you don't want hidden?

 

[Osvaldo Palmeiro]

Please, try this:

Private Sub Worksheet_Change(ByVal Target As Range)
 Dim LR As Long, NP As Range
  If Target.Count > 1 Then Exit Sub
  If Target.Column <> 5 Or Target.Value = "" Or Target.Offset(, -1).Value = "" Then Exit Sub
  LR = Cells(Rows.Count, 4).End(3).Row
  For Each NP In Range("D2:D" & LR).SpecialCells(xlVisible)
   Rows(NP.Row).Hidden = Cells(NP.Row, 4) = Target.Offset(, -1).Value And NP.Row <> Target.Row
  Next NP
End Sub

 

[XrayLemi]

This works perfectly! Thank you so much!