Hi board:
I have two worksheets: #1 has several columns of employee information, including a column with their email address. Worksheet #2 has same employees responses to a survey and each set of responses has the employee email address. I need to somehow merge these two worksheets so that I have all information on one worksheet (from which I can do a pivot table to divide responses by location, job description, etc.). I know I can match by the employee email address, but how do I do that?
I have two worksheets: #1 has several columns of employee information, including a column with their email address. Worksheet #2 has same employees responses to a survey and each set of responses has the employee email address. I need to somehow merge these two worksheets so that I have all information on one worksheet (from which I can do a pivot table to divide responses by location, job description, etc.). I know I can match by the employee email address, but how do I do that?