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


--
Davegrier
------------------------------------------------------------------------
Davegrier's Profile: http://www.excelforum.com/member.php...o&userid=31171
View this thread: http://www.excelforum.com/showthread...hreadid=508309