Hi guys.
I have a table with hundreds of thousands of article numbers connected to customer numbers. All our article numbers comes in different sizes, but many customers have some sizes registered, but are missing some.
I have 2 tables:
1. With all the article numbers with the customer numbers connected
2. All article numbers with all the available sizes
Is it possible to make a table where the customers get all the sizes to the article numbers the already have registered?
OS: Windows
Excel: 2016
VBA: Preferably not
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Article Number[/TD]
[TD]Customer number[/TD]
[/TR]
[TR]
[TD]011.0400-9[/TD]
[TD]999[/TD]
[/TR]
[TR]
[TD]011.0400-11[/TD]
[TD]999[/TD]
[/TR]
[TR]
[TD]011.0744k-8[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]412.499-11[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]412.499-10[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]412.499-9[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]412.499-12[/TD]
[TD]1001[/TD]
[/TR]
[TR]
[TD]412.499-11[/TD]
[TD]1001[/TD]
[/TR]
[TR]
[TD]412.499-10[/TD]
[TD]1001[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Article Number
[/TD]
[TD]Sizes
[/TD]
[/TR]
[TR]
[TD]011.0400-8[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]011.0400-9[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]011.0400-10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]011.0400-11[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]011.0400-12[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]412.499-9[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]412.499-10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]412.499-11[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]412.499-12[/TD]
[TD]12[/TD]
[/TR]
</tbody>[/TABLE]
I have a table with hundreds of thousands of article numbers connected to customer numbers. All our article numbers comes in different sizes, but many customers have some sizes registered, but are missing some.
I have 2 tables:
1. With all the article numbers with the customer numbers connected
2. All article numbers with all the available sizes
Is it possible to make a table where the customers get all the sizes to the article numbers the already have registered?
OS: Windows
Excel: 2016
VBA: Preferably not
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Article Number[/TD]
[TD]Customer number[/TD]
[/TR]
[TR]
[TD]011.0400-9[/TD]
[TD]999[/TD]
[/TR]
[TR]
[TD]011.0400-11[/TD]
[TD]999[/TD]
[/TR]
[TR]
[TD]011.0744k-8[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]412.499-11[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]412.499-10[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]412.499-9[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]412.499-12[/TD]
[TD]1001[/TD]
[/TR]
[TR]
[TD]412.499-11[/TD]
[TD]1001[/TD]
[/TR]
[TR]
[TD]412.499-10[/TD]
[TD]1001[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Article Number
[/TD]
[TD]Sizes
[/TD]
[/TR]
[TR]
[TD]011.0400-8[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]011.0400-9[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]011.0400-10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]011.0400-11[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]011.0400-12[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]412.499-9[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]412.499-10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]412.499-11[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]412.499-12[/TD]
[TD]12[/TD]
[/TR]
</tbody>[/TABLE]