VBA script to compare two workbooks and return differences between the two?

**pizzaguy4487** · 09-28-2018, 10:02 PM

Hello all and thanks in advance for any help you may give this noob.

I have two excel workbooks...

One is called Master Employee List. It contains employee names, store #, ss#'s, hire dates, and a bunch of other manually entered data. All of this data is in one row per employee. I have each store # (individual location) in a different sheet, 11 total sheets.

The second workbook is called Active Employee List. I export this file from my stores' databases weekly (it exports all stores into one excel file). It also contains employee names, store #, ss#'s, hire dates, and a lot of other data..again all in one row per employee.

What I am trying to accomplish is to be able to identify if there is a new employee in the Active Employee List that is not in the Master Employee List, and also identify if someone from the Master Employee List is no longer an employee since they are missing from the Active Employee List. This could be accomplished by either highlighting the employee in each file that is missing from the other, or more preferably creating two new sheets in the Master file called New Employees and Terminated Employees. The only data I would need to have returned is the Store #, Employee Name and ss#. That would be Rows A,B,C and D (Store #, Last Name, First Name, SS#).

Any guidance on this would be most appreciated.

Thanks!
CJ

**alansidman** · 09-29-2018, 12:31 AM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.