VBA Code will not work automatically when cell value met - have to manually run code?

Dear Experts,

I came across some vba coding to help me cut and paste a row of data automatically from one sheet to another when cell value is met. The code will work if I go to the Visual Basic Editor and press the Run Sub/User Form (sometimes I have to click it a couple of times to get it to work- not sure why!) but I want the code to work automatically when the cell value in column 'E' equals 'NO' and not have to click Run Sub/User Form in Visual Basic Editor.

Can someone help me to modify the code to work automatically as I can not see what is wrong. I am working with excel 2013 and I have attached the test workbook to help.

Many thanks in advance for any help given.
Kaz