VBA - If contents of cell on different sheet don't appear in column, add to first available row

[The Great SrH]

Hi,



I'm looking to find some code for a spread sheet I'm building.


Basically, Worksheet 1 is my data page which pulls from SharePoint. In Column D starting in Row 2, will be the "Team Manager" of an advisor.



In Worksheet 2, I'm going to have list of all Team Managers in Column A, with their Senior Leader in Column B. This sheet will all be manually input (apart from the bit I'm about to ask).


I need a code to basically check the Team Manager data in Worksheet 1, against Worksheet 2, and if a Team Manager appears in Worksheet 1 (but not 2), I want that name adding to the bottom of Worksheet 2's list in the first available row.



Sorry if this is a bit wordy!

Thanks in advance.

 

[The Great SrH]

Happy to provide a bit more information if this wasn't clear enough?

 

[The Great SrH]

Anyone?