Alright here is the problem, I have names of people, their coach and team in three comlumns on sheet 1. I need to check sheet 1 with an updated roster I get each week, lets call that sheet 2, so that I can input the new changes on sheet 1. I what to tell Sheet 1 from sheet 2 if a person is New altogether or maybe he switched teams or got a new coach. So basically I want a new column in sheet 2 beside the names, coaches, and team to tell me if a person is new, got a new boss, or changed teams. And maybe if it can even be done input its self into sheet 1 and fix the data there. So I do not manually have to fix the data in Sheet 1.


Thanks for any help or hints.