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

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

Thus my question. Is there a way to compare the list from last week's
spreadsheet to this week's spreadsheet and flag new listings that
appear on the new sheet, but were not on the old sheet. And conversely
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 retain
the names from sheet2, but flag them as inactive.


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

--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=467546

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

Gilles

"DCSwearingen"
wrote in message
news:DCSwearingen.1vcwek_1126713945.0325@excelforu m-nospam.com...

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

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

Thus my question. Is there a way to compare the list from last week's
spreadsheet to this week's spreadsheet and flag new listings that
appear on the new sheet, but were not on the old sheet. And conversely
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 retain
the names from sheet2, but flag them as inactive.


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

--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile:
http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=467546