searching through data

I want to look through a column and import data into another worksheet based on whether there is a No or Yes in the specified column. Any ideas on how i can accomplish this

Sort Data using the Yes/No column
Highlight and copy rows you want, Copy
Paste into the other worksheet.

Or

Use Data Menu
Apply AutoFilter
Select Yes or No from the Autofilter
Select all displayed data, Copy
Paste into the other worksheet.