Wanting to move to top and hide a row in a table once a value in column K ="CLOSED"

[RedStag750]

I've been trying to find a Macro that updates my table automatically when you enter "CLOSED" into column K that then moves it to the top and hides it. I want it to go to the top because the worksheet has lookup coding in it. It is a pain if the closed rows are on the bottom and hidden.

 

[kevin9999]

Could you provide a copy of your sheet using the XL2BB add in, or alternatively share your file via Google Drive, Dropbox or similar file sharing platform?