Help!!! With VBA

[Tim326515465]

see attached there are 3 sheets
I will be looking at two sheets "Data" and "Doc". I need to match the "name" from "data" to the "name" from "doc". "doc" will have multiple duplicates of the name with a different "file". I will need to have the "doc" create new rows with "name" and "op" copying exactly the same and the "file" will be different. will also need the "name" from "doc" could be the same but "op" will be different so it will need to distinguish between that. I have a sheet name "results" columns highlighted in grey is what im looking for, column in yellow is what i am getting. I think this will need to be in VBA. I will greatly appreciate any help i can get. Thanks

If columns need to be added to "data" or "doc" to help with this, it should be ok.

 

[Luke M]

I think the yellow on right is actually more correct. The data name "12356" has two options, 400 and 500. So, for each of those OP, you need to list out all 6 files associated with "12356", right?

 

[Tim326515465]

No it wont be for what i am needing it to be. 400 can only have 3 files and 500 can only have 3 files or it could be just 1 file like for "name" 123 or 1234

 

[Luke M]

What is the logic behind that? The previous one, "1234" with OP 300 has 4 files associated withi it?

 

[Tim326515465]

Each name can only contain 1 file and/or 3 files. 123 and 1234 contains 3 files and also 1 file

 

[Luke M]

1234 has files: a2, b2, c2, and F2.