VBA to find out missing combination

Hi Guys,

Once again I would need you help please.

I really need a VBA code to find and identify missing combination between values organized in two columns A:A & B:B.

• Column A is populated with a list (very long, about 50K) of part numbers.
• Column B is populated with 9 location codes: NL10; AU21;CH20;NL20;NO20;NZ20;RO20;SE20;ZA20

Actually all the part numbers in A:A should be repeated nine times as each of them should be present in all the locations, NL10 is compulsory so is always there.
The code should check and find out what are the missing locations for each part number.
I've attached a sample to explain practically what the VBA code should do and how my worksheet is organized.

PLEASE help

Hi Alansidman,

thanks for you help

not sure I understood you.

you've built a table using data that you are supposing it is already there...but I don't know which plants are missing, so I cannot build the table...the only initial data that I have is what you see in columns A and B, in the real scenario all the other columns would be empty (I filled them in as an example of what VBA should do)

How could I fill in the table when you have more than 50k part numbers?
I agree with you pivot strategy but after I have all the data, but first I have to get it... or Am I wrong and I didn't get your suggestion?

Thanks!

ah Got it! thanks a lot, sorry if I didn't catch on the spot, yes I can use a pivot table and then I can also export data out of the pivot and filter at will.

Thank you so much mate!