Hello,
I need to compare data on two separate spreadsheets that are organized differently. I have a master spreadsheet that lists employees and related information (Region, department, title, etc.). All employees are listed on a single worksheet. I have a separate spreadsheet that has similar information on it, however this spreadsheet lists the employees on separate worksheets for each different region.
The master list is more recent. I need to compare the master list against the older separated worksheet to determine:
Thanks.
A sample of the spreadsheet data is as follows:
I need to compare data on two separate spreadsheets that are organized differently. I have a master spreadsheet that lists employees and related information (Region, department, title, etc.). All employees are listed on a single worksheet. I have a separate spreadsheet that has similar information on it, however this spreadsheet lists the employees on separate worksheets for each different region.
The master list is more recent. I need to compare the master list against the older separated worksheet to determine:
- If there are any new employees
- If any employees have left
- If any employees have changed title.
Thanks.
A sample of the spreadsheet data is as follows:
Region | Employee Name | Department | Title |
North | John Smith | Sporting goods | Supervisor, Customer Service |
North | Jane Doe | Appliances | Sales Associate |
East | Bob Smith | Grocery | Sales Associate |
West | Mary Johns | Grocery | Supervisor, Customer Service |