Add/remove rows to a range based on filter rows of another range

Hi,

I have table "Users" which has 2 columns username and usertype, where usertype can be "student" or "teacher". This table is periodically updated from external data source (usernames and usertypes may be changed, and new rows may be added for new users or existing rows deleted as users are removed from the data source).

I have another table called "Students" which has 2 columns "username" and "grade". This table contains only the entries from Table "Users" that have usertype = "Student". The grades need to be manually input for each student in Excel.

The problem I want to solve is this.

Periodically, the Table Users will be updated as mentioned above. I would like a VBA solution that goes through the "Students" table, remove all rows that are no longer in the "Users" table, add new rows that are in the "Users" table but not yet in the "Students" table, and (optional) highlight them so that I know these users need to have their information updated.

Does anybody have a piece of code that does something similar to this?

Thanks!

Jube