Search separate sheets to find matching model numbers and return results in another sheet

[Jay S.]

Hello Experts!

I have a need to search through three separate sheets to find common model numbers listed in project lists and return the data into another sheet. I've attached the general sheets and examples of what I'm looking for.

The "PROJECT MATCHES" sheet shows how I need to compile the matching data.

The other three sheets are where the project information comes from.

Looking for a VBA routine to loop through each sheet and return data.

Thoughts or better suggestions?

Thank you,
Jay

[Logit]

.
If everything else matches in your search criteria, is it the "RESOURCE/S" you are attempting to fill in on your PROJECT MATCHES sheet ?

Also, line #4, Jim/Dan don't seem to be correct for the other data on the line.

[Jay S.]

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).

[Logit]

.
When performing a search there is usually a single key word or phrase that is being searched for.

From your last explanation, do I understand correctly that you are searching on Column F - "Matching Model number(s) of device(s) under review" ?

So for line 3, you would be searching for "303" and the other columns in line 3 would fill in ?

[Jay S.]

Hi Logit,

Well, it's a bit tricky. The search criteria will be fluid since it may not always be "303" or "333" that is being looked for (more like finding duplicates within a cell). Anytime there is a match in
Column F - "Matching Model number(s) of device(s) under review" across the three sheets "A, B and C Projects" I need it to return the row into the next available row in "PROJECT MATCHES" sheet and
add an "X" to the correct column in that sheet as well (i.e. "A Projects", "B Projects", etc...).

Thanks,
Jay

[Jay S.]

For a little more clarification -

1.) There are three project teams (A Projects, B Projects, C Projects)
2.) Each team will work on different projects ("Project Description")
3.) Each team *MAY* be impacting the same Model number of a device we sell
4.) Need to identify which team (A,B,C) and what model number is being affected by separate projects

It's like a project "overlap" identification tool. The results should be copied and placed into the "PROJECT MATCHES" spreadsheet for review.

So the "search" criteria will be ever changing as it just needs to loop through to see if there are any "Duplicate" items/model numbers found across the three sheets (A, B, C).