save/paste column

[kamalmalek]

dears,
i have simple issue

users update some info in column A
I need to copy all in A timely and paste in column B but without duplicate
i need to update TIMELY and not affect "small or big letter"
as below:

A B
JOU JOU
JOU Larry
Larry micle
Larry
larrY
micle

[Bob Phillips]

Use Advanced Filter, it has a unique values option.

[kamalmalek]

thanks XLD
but i need timely,
like if i use advance filter, it is okey but "then" if client add same cell before will not be effected in advance filter list,
i need same below:
A B
JOU JOU
JOU Larry
Larry micle
Larry
larrY
micle

[Bob Phillips]

So you code the AF, and use a change event to trigger it.