Delete Unwanted Rows

On the attached example I want to add some code to the Command Button that when pressed deletes the rows where column J has the text "No Shops".

Any ideas on how to write the code?

Cheers.