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
Bookmarks