Filter by Customer and select 20 Materials

[carol506]

Hi Guys,

I would like to request your help with this macro. I tried several times but I'm not sure how to do that .

I need to filter for a customer and select 20 materials minimum for each one.

Note : I have around 100 different customers

Customer Materials
[TABLE="width: 140"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 140"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]69004607[/TD]
[TD]80296073[/TD]
[/TR]
[TR]
[TD]69004607[/TD]
[TD]80296079[/TD]
[/TR]
[TR]
[TD]69004607[/TD]
[TD]80296093[/TD]
[/TR]
[TR]
[TD]69004607[/TD]
[TD]80296451[/TD]
[/TR]
[TR]
[TD]69004607[/TD]
[TD]80297769[/TD]
[/TR]
[TR]
[TD]69004607[/TD]
[TD]80299106[/TD]
[/TR]
[TR]
[TD]69004607[/TD]
[TD]80303570[/TD]
[/TR]
[TR]
[TD]69004607[/TD]
[TD]80278519[/TD]
[/TR]
[TR]
[TD]69004623[/TD]
[TD]80210326[/TD]
[/TR]
[TR]
[TD]69004623[/TD]
[TD]80220104[/TD]
[/TR]
[TR]
[TD]69004623[/TD]
[TD]80248329[/TD]
[/TR]
[TR]
[TD]69004623[/TD]
[TD]80256100[/TD]
[/TR]
[TR]
[TD]69004623[/TD]
[TD]80256105[/TD]
[/TR]
[TR]
[TD]69004623[/TD]
[TD]80256113[/TD]
[/TR]
[TR]
[TD]69004623[/TD]
[TD]80256200[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]