Cross checking between spreadsheets with multiple worksheets

Sirod

New Member
Joined
Aug 6, 2009
Messages
33
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:
  1. If there are any new employees
  2. If any employees have left
  3. If any employees have changed title.
I'm not sure what formula I need to accomplish this. Please no VBA as I'm not proficient at it.

Thanks.

A sample of the spreadsheet data is as follows:
RegionEmployee NameDepartmentTitle
NorthJohn SmithSporting goodsSupervisor, Customer Service
NorthJane DoeAppliancesSales Associate
EastBob SmithGrocerySales Associate
WestMary JohnsGrocerySupervisor, Customer Service
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,113,749
Messages
5,543,979
Members
410,587
Latest member
kaloybulan
Top