Hi,

\1

In the picture you can see I selected N4082:N4096. What I want is that a macro searches this area and copy-paste every unique value into column T.

So in this case it will list the following:

ROEFS
WILKEN
VANDENBERGH
VERBAETEN
SMEULDERS
551001

Any help is much appreciated


Tom