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
[
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
[