New users automatically added to a contact list

Hello all,

I have a simple user file in which data is pasted from a report by a macro to an "Output" tab. User names and email addresses aren't present on the report, so those are added using a simple VLOOKUP function which seraches for information in a "Contacts" tab. The VLOOKUP is based on a unique user code assigned to each user.

Any new users who aren't in the list in the "Contacts" tab are shown as "No user name" and "No user contact" in the "Output" tab.

The same user may be present in more than one line, and the report varies every week in length.

What I'd need is VBA to quickly filter the new users (i.e. those which show "No user contact"), and copy their user codes at the bottom of the appropriate column in the "Contacts" tab, de-duplicating any multiple entries, ready for me to enter their name and email manually.

Attached is a sample file of what I mean.

I'd be very grateful for any help you can provide me, it'll save me a lot of manual work.

-Isa

Hello Martin,

This is perfect, thank you so much.

-Isa