Is there a way to select all rows in a list that contain a "yes" in the
first column of that list? I want a macro to copy only those rows with a
"yes" in the first column and paste those rows to another worksheet.