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

You still have not resolved the issue yet.
I remember you had an event driven, but was not working for you, though, it did work when I tested it. I had written you another code, but you are back to square one. The attached code is not even driven code.

Sixthsense,
The OP had a working code(Not the attached). The code was posted with an attachment. The code was working fine, but for some unknown reason, it did not work on his PC. I made some suggestion, but to no avail.

Here is the link

http://www.excelforum.com/excel-prog...03#post3361403

Sixthsense,
Look at the link!
There is a code on the sheet no 17(Post #1)

Please Login or Register  to view this content.

Dear AB33, I am very sorry if I have caused any problems. All I am trying to do is resolve an issue that I have. As explained, I could not get the code to work no matter what I tried with and without your guidance. As stated, I was looking for a code I could use to automatically cut and paste rows of data from one sheet to another based on cell value, which is what Sixsenth is helping with. I thought I would try and use a different code but not being very experienced with VBA coding I tend to play in the dark and try to make coding I find suit my needs but no matter what I tried I could not find an automatic solution hence the request for help.

Apologies if I have offended you.

Kind regards
Kaz

Kaz,
Not at all!
The bottom line is to get a solution. Hopefully, this new code works for you.

Dear AB33,

Thank you. I was worried that I had done something very wrong. I hope in the future that if I need some additional help you will still be happy to help. I am just looking at the revised coding given by Sixsense.


Thanks,
Kaz