Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! -How to compare two worksheets; multiple rows of data=result | Excel Worksheet Functions | |||
Compare data in 2 worksheets | Excel Discussion (Misc queries) | |||
compare data in 2 worksheets | Excel Worksheet Functions | |||
Compare Data in two Separate Worksheets | Excel Discussion (Misc queries) | |||
compare worksheets data | Excel Discussion (Misc queries) |