Cut & paste row automatically from 1 sheet to another based on formulated cell value

Dear Experts,

I have a workbook with two worksheets in it and what I would like to do is automatically cut and paste rows from one sheet to another based on cell criteria. I have used some vba coding that I have found but it will not work as the cell/column I base the information on has a formula built in to it and it seems to stop the vba code from working. Can someone please advise what I am doing wrong and show me how to correct it. I have attached a sample workbook for you.

Many thanks in advance for any help received.

Kaz

I have tested it and it works.
You need to check if your enabled events have been turned-off

Hi AB33,

Sorry, how do I enable events or check to see if they are turned on.

Thanks,
Kaz

While at VBA project window, choose View-Immediate window. or CRLT+G while your cursor is on VBA project. You will get a window. Type

Application.EnableEvents = True
and hit the enter button. Go back to excel and try it and should work.

Thank you for that but I still can not get the code to work. What else could I be doing wrong as the rows with 'No' against them are not moving over to 'Sheet1' as per the VBA code.

Thanks,
Kaz

If you do it correctly, you need to enter No in column E (Any row), or drag the formula which gives you E value.

Hi AB33

I am very sorry but no matter what I try I can not get the rows with 'No' against them in column E to automatically transfer to sheet 1. I have done everything you said, even entered 'No' manually in column E just in case the formula to determine 'No' was incorrect but nothing I try works. Is there anything else you or someone else can suggest, even if it means using different VBA coding as the combination of VBA coding and formulas I am using in column E is clearly not working for me. I am using excel 2013 is this is making a difference.

Thanks,
Kaz

The code works for me. As soon as I changed column E in No, that row has moved to sheet1.
If the code does not work, remove it and use a filter code instead, but this code is no auto fired, you need to run it.