Code:
Option Explicit
Sub HideRowsContainingValue()
'Description: This macro will loop through a col and
'hide the row if the cell in Col A does not the value of A1.
Dim c As Range
Application.ScreenUpdating = False
For Each c In Range("A2:A100").Cells
If c.Value <> Range("A1").Value Then
c.EntireRow.Hidden = True
End If
Next c
Application.ScreenUpdating = True
End Sub
The above macro will accomplish what you want in the workbook I provided.
Your original post indicated you wanted to view anything EQUAL TO or GREATER than the
STARTDATE, which is why the first macro was written as it was.
HTH