Question: how to copy data from one sheet to another based on criteria?
Answer: Select the column which you will copy rows based on, in our example select the Fruit column. ...  Click the Arrow besides the specified Column Header, and then only check the specified fruit in the drop down list, and click the OK button.