Joined the forum because of this post. It was difficult to find a place that would show how to use the Find method, and actually provide examples.

I do have a question. I've modified the Scenario 4 and am wondering how to incorporate this into use for two separate workbooks. So my UpdateRange is one one workbook, and my DataRange is on another. I can save where the workbooks are, but run into problems in getting aCell = bCell. Any help on ensuring proper syntax for those?