This seems to work but I have to run it for it to hide the completed. It doesn't do it in real time
![]()
Sub Macro1() Dim myrange As Range Set myrange = Range("M:M") For Each cell In myrange If cell <> "" Then If cell.Value = "Complete" Then cell.EntireRow.Hidden = True End If End If Next cell End Sub
Bookmarks