Find Missing Location VBA

[isasa74]

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

[

 

[S.H.A.D.O.]

Hi isasa74, unfortunately the attachment is not showing.

 

[isasa74]

Hi isasa74, unfortunately the attachment is not showing.

Hi S.H.A.D.O,

thanks for your reply, I saw just now that I'm not authorized for attachment, how could I do then please?
thanks again