Comparing Two Spreadsheets

[DCSwearingen]

Each week a spreadsheet is created by pulling a list of active employee
from the payroll database. Obviously the payroll database is ver
restricted for access, so I have to depend on the spreadsheet.

I do some tracking of employee involvement, so I need to have m
listing up to date, but I don't want to lose the ideas from employee
just because they are no longer active employees.

Thus my question. Is there a way to compare the list from last week'
spreadsheet to this week's spreadsheet and flag new listings tha
appear on the new sheet, but were not on the old sheet. And conversel
flag the names that were on the old sheet, but not on the new sheet.

I have attached a zip file with two worksheet tabs that I might use.
Sheet1 has approximately 45 fewer names than Sheet2. I want to retai
the names from sheet2, but flag them as inactive

+-------------------------------------------------------------------
|Filename: Lists.zip
|Download: http://www.excelforum.com/attachment.php?postid=3821
+-------------------------------------------------------------------

 

[Gilles Desjardins]

Try the following site for a trial download
http://www.formulasoft.com/

Gilles

"DCSwearingen" <[email protected]>
wrote in message
news[email protected]...