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

Hi soco3594

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.