collecting data without repeating items...

[peterschein]

Dear Experts,

I am new to VBA and I have a pretty complex task to solve.. (please see the task and description in the attachment below)

I have in column x some group names and in column y article names to it.

If a coworker writes a groupname in a designated cell, all the article names that matches the group name should be listed somewhere.

the trickiest part: without repeating... so if an article name was listed once it should not be appear again...

Is it even possible?


Thank you indeed for your help!

Best regards
Peter