Hi All - I need your assistance with Excel. I have a worksheet with the following columns.
EmployeeNumber (Column A), Employee_Name (Column B), EmployeeName (Column C),username (Column D) ,email (Column E) and Employee_Number (Column F)
Column A and column B contains the employee numbers and names for a single department, however, the rest of the columns C, D, E, and F contain employee information for the entire company (but column F is sometimes blank.)
The number of employees for a single department are about 700 and the total number of the entire company is about 50000,
I would like to check if the employee from employee_name (column B) exist in the EmployeeName (Column C), if it does then get the ,username (Column D) ,email (Column E) and Employee_Number (Column F) for the employee to be copied to another sheet. if employee_name (column B) does not exist in EmployeeName (Column C) then ignore.
Is it possible to automated this rather than manual? It will take me a log time if I do this manually.
I have attached a sample spreadsheet, there are two worksheets, worksheet 'Before' contains all columns and worksheet 'After' contains the results.
I hope my explanation make sense, if not please by all means ask me question.