Compare worksheets with multiple data

N

NeSchw6G

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!
 
M

Michael

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top