Hello, great board you have here.

My question is this:
I have a static list of employees, start dates, and supervisors in 3 columns:

Bob Smith | 01/06/94 | Jones
Jen Baker | 05/06/03 | Anderson
etc.

I need to compare this static list to a new list I receive daily of those employees that worked each day. I have the list of employees (in a standard repeatable format, the names will not vary in case or spelling) and I need to fill in the start date and supervisor in 2 columns next to the name.

I have a template already, so I can keep my static master list on a separate worksheet, but I'm not sure how to compare one list to another and extract the relevant data.

Thanks for the help!

Dave Grier