Question: how do i copy data from one worksheet to another based on the 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.