Hide rows based on drop down list

Hi guys,

I'm creating a basic sales tracking spreadsheet for a consultancy I'm working for. All new jobs (or BD opportunities) are added to the spreadsheet and a status is assigned to the job (Positioning, Pursuit, Proposal, Closed, Won or Lost).

I want to display entries for a given status only based on a drop down list. i.e. if the user selects "Positioning" from the drop down list, only jobs marked as "Positioning" will be shown. All other rows will be hidden. I know this can't be too hard, but it's been a while since I've played with VBA.

I've put together a basic example but can't work out how to attach it...

Thanks in advance!

try one of these methods
https://www.excelforum.com/the-water...his-forum.html

My apologies....Change event code...source:Experts Exchange

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim row As Double
Dim hide As Boolean
    If Target.Address = "$D$2" Then
        For row = 5 To UsedRange.Rows.Count
            hide = True
            If Cells(row, 3) = Target Then hide = False
                Rows(row).Hidden = hide
        Next row
    End If
End Sub

Hi soco3594

Option Explicit
Sub HideMe()
Dim lrow As Long
Dim i As Integer
Dim ws As Worksheet
Set ws = Sheets("Jobs")
lrow = ws.Cells(Rows.Count, "C").End(xlUp).Row
With ws
For i = 5 To lrow
    If .Cells(i, 3) <> .Range("D2").Text Then
        .Cells(i, 3).EntireRow.Hidden = True
    End If
Next i
End With
End Sub