Hi, I have 2 sheets with data downloaded. I have cross-referenced them and have "yes" and "no" results in Column A in each sheet. I am trying to copy rows with "yes" in column A. I need them to be separate macros because I will have another macro to tidy up the data from "DSS download" table...