Hide rows with column marked Complete?

[jimnboken]

I'm trying to setup an excel sheet that lists a lot of projects... clos
to 400 lines worth already.

The more projects we complete the more cluttered it becomes. We don'
want to remove the completed projects but it would be nice to turn of
those rows.

Is there a simple way to setup a "toggle" or something that would hid
the rows which have a column with the text Complete in them?

We would like to be able to unhide easily as well so we can mak
reference to previous projects, and then hide them again.

Thanks very much!!
Ji

 

[mzehr]

Try using Data/Filter/Autofilter. Then select the drop
down arrow over your completed column, and
select "Completed". Highlite those rows and hide.

HTH

 

[Gord Dibben]

Jim

Sub delete_completes()
Dim c As Range
With Columns("C") 'alter to suit
Do
Set c = .Find("complete", LookIn:=xlValues, LookAt:=xlPart, _
MatchCase:=False)
If c Is Nothing Then Exit Do
c.EntireRow.Hidden = True
Loop
End With
End Sub

To unhide rows just click on the gray box at the top intersection of row and
column headers. Right-click on any row header and "unhide".

Gord Dibben Excel MVP