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