Question: how to transfer data from one sheet to another in excel based on criteria?
Answer: Select the range that you will copy rows based on column criteria, and click the Enterprise > Split Data. In the opening Split Data into Multiple Worksheets dialog box, you need to: ...  Click the Ok button.