Add unique values to unique column and loop

[martinus1988]

Hi all,

I have a list in column C (in sheet "Test").
I have a unique column A (in sheet "Articles")

iam looking for a macro thats adding unique values to column A. So it has to campare both colums and add the unique values of column C (that arent in column A already). Anyone got an idea.

A
TEST1
TEST2
TEST3
TEST4
TEST5
TEST6

B
TEST3
TEST4
TEST5
TEST8
TEST27
TEST92

In this case it has to add TEST1,2,6 to coulmn B