Searched all over for Clear Instructions on Referencing a Column of Values in One Sheet in Another


I have one sheet (list of Employee). Each employee has an Employee ID (auto column).

I have another sheet (Hours per Employee). Each employee submits their hours worked via a form.

I want the Employee IDs that exist in the list of Employees to automatically be listed in the Employee ID field of the Hours per Employee form.

How do I accomplish this? Please provide pictures and clear steps so that I can get past this issue?

Wendy D. Oliver, M.Ed., PMP, PMI-ACP, PMI-ATP


OLIVE BRANCH Project Services, LLC