Hello,

I have a table of 1000 rows and 10 columns from A to J. Title heading are in row 1. In column 10 there are words "yes" or "no" in each row.
How can I copy all rows from the table for each contractor name from column A and with word "no" based on column 10 and paste those rows starting in row 1010 of he same sheet.

If anyone can help with a Macro, will be much appreciated.

Thank you