jose11au
asked on
Excel - to match employees from multiple lists
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.
Many Thanks
Jose
Example.xlsx
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.
Many Thanks
Jose
Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much for your help guys.
You're welcome. Glad I could help.
You could use a helper's column to filter the data
Open in new window
But beware with such a large amount of names you could have duplicates or misspelled onesRegards
Example_V1.xlsx