Hi, everyone. I’mtrying to automate a project. In past I have been able to compare a columnin Sheet1 to a column in Sheet2 and when a match is found copy the entire rowfrom Sheet2 to another worksheet with a VBA loop. But this was always based there being onematch. What do you do when...