Hi Logit,

Thanks for your response.

I'm trying to populate the "PROJECT MATCHES" sheet by looping through the other three sheets. If you look on sheet "A Projects" and "B Projects", you'll see that both Jim and Dan (rows 5 in each) have a project that affects model number "333" (red text). When this is identified, I need to copy the entire row or project and display it on the "PROJECT MATCHES" sheet. The "X" on the "PROJECT MATCHES" sheet should also populate based on where a match it found...in this example, on both sheets "A Projects" and "B Projects".

In my example worksheet there is also a model number match in all three project sheets (A,B and C) for model "303" (1st line in each sheet).

Think of the "PROJECT MATCHES" sheet as a sort of "dashboard" of information that can be easily reviewed to show projects that affect the same model number of a device or product on three separate teams (A, B and C Projects).