How to automatically move data from one sheet to another (Cut-Paste Automatically)

Dear All,

I have problem in excel. I have data that needed to move from sheet1 into sheet2 if the data in column E (header name = D) is yes.

For example, the data in row 4 column E is Yes, i want it moved automatically to sheet2. (And the data in sheet1 deleted)

Sorry for my bad english, hope you understand.


Project_Example.xlsxProject_Example.xlsx

Dear Vikas,

Thank you very much for your respond. I try your code to my real data, but it's not worked, can you help me 1 more time please?

I want to move the data in column T in sheet1 to sheet2 if column T >0.

Many thanks for your help. I really-really need this. God bless you.




Project_Example2.xlsx

Dear Vikas,

I've try that code, but it's still not working. The error text : Run-Time Error '1004'. Do you have any idea how to solve this problem?

Can someone help me, please?