I have an Excel 2003 workbook that contains several worksheets showing data
that I want to be able to add to one of the worksheets and use as a staff
roster. The information is imported from an Access 2003 mdb which is updated
on a daily basis.

My Staff Roster worksheet has column headers for Last Name, First Name,
Employee Number, Department, Hire Date, Seniority Date, and so on and so on.
I'm using the List feature to display selection choices in many of the
columns which pull data from one or more of the other worksheets.

When I select an employee number (say in Cell A1) form the EMP_List, I also
would like to pull the employees Last Name (from EMP_List to Cell B1) and
First Name (from EMP_List to Cell C1).

First can this be done and secondly, if so how would I go about this?

Mike