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