LookUp EmpID

Hello to All,
		If in the dataentry sheet I enter employeeID that does not exist, then
switch to Employee sheet and add the employeeID, Last and First name. Switch back to the
dataentry sheet should automatically populate the info for that employee.
Please see the Worksheet_Change() code.

Thank for any help.