Compare worksheets with multiple data
 

I need to compare 2 worksheets of data, each worksheet contains:

Worksheet 1
Last Name First Name Date Location Rate Code Code2
Allen Joe 9/27/07 3-NV $30,000.00 27700 534
Adams Cindy 9/25/06 3-NV $40,000.00 27700 513
Smith Salley 11/20/07 2-NY $40,000.00 27700 578
Brown August 12/12/07 1-CA $40,000.00 27700 512
Donaldson Matt 3/2/08 5-FL $40,000.00 27700 560

Worksheet 2
Last Name First Name Date Location Rate Code Code2
Allen Joe 9/27/07 3-NV $30,000.00 27700 534
Adams Cindy 9/25/06 3-NV $40,000.00 27700 815
Brown August 12/12/07 1-CA $50,000.00 27700 512
Donaldson Matt 3/2/08 5-FL $40,000.00 27700 560
Brenning Karen 4/1/08 1-CA $50,000.00 27700 560

I need to find anyone who is on 1 sheet but not the other; I also need to
recognize any changes made for each person between the sheets. I.E. I need
excel to tell me that-
Salley Smith is in 1 but not 2
Karen Brenning is in 2 but not 1
August Brown's rate changed
Cindy Adams' code2 changed

Is this possible? If it could actually highlight the changed information
that would be even better.

Thanks!

Compare worksheets with multiple data
 

This type of comparison is much easier using access. Access has built-in
functionality and predefined queries that allow you to create a report that
will indicate what is in one table and not in the other.
For excel it will require a fairly large amount of programming and user
interaction.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"NeSchw6G" wrote:

I need to compare 2 worksheets of data, each worksheet contains:

Worksheet 1
Last Name First Name Date Location Rate Code Code2
Allen Joe 9/27/07 3-NV $30,000.00 27700 534
Adams Cindy 9/25/06 3-NV $40,000.00 27700 513
Smith Salley 11/20/07 2-NY $40,000.00 27700 578
Brown August 12/12/07 1-CA $40,000.00 27700 512
Donaldson Matt 3/2/08 5-FL $40,000.00 27700 560

Worksheet 2
Last Name First Name Date Location Rate Code Code2
Allen Joe 9/27/07 3-NV $30,000.00 27700 534
Adams Cindy 9/25/06 3-NV $40,000.00 27700 815
Brown August 12/12/07 1-CA $50,000.00 27700 512
Donaldson Matt 3/2/08 5-FL $40,000.00 27700 560
Brenning Karen 4/1/08 1-CA $50,000.00 27700 560

I need to find anyone who is on 1 sheet but not the other; I also need to
recognize any changes made for each person between the sheets. I.E. I need
excel to tell me that-
Salley Smith is in 1 but not 2
Karen Brenning is in 2 but not 1
August Brown's rate changed
Cindy Adams' code2 changed

Is this possible? If it could actually highlight the changed information
that would be even better.

Thanks!