Comparing Two Spreadsheets

[DCSwearingen]

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.

[Gilles Desjardins]

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

Gilles

"DCSwearingen" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>