Make a Row Automatically Hide When Completed Selected

[Squint]

I used to have an Excel spreadsheet that a colleague that does VBS coding created for me. I can not do VBA coding and wondered if anyone may be able to do something similar with the attached spreadsheet. This is an action item list that I will be using. Column F represents the Status. If I select "Completed" from the drop down I would like the entire row to automatically hide. I would still be able to unhide when/if I needed to see the row again. Any help is always appreciated

[BadlySpelledBuoy]

There's no attachment.

BSB