Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare 2 worksheets all 6 columns in each worksheet
Hello
Each week we produce a report of peoples time and bill this. It has 6 column fields. The person entering their time can go back and change their time(Hours) up to 2 weeks back. We can re-obtain the data and would like to run a compare against both worksheets and where there are differences copy that line in another worksheet and show the difference for that whole row. There are many resources but we expect very few changes...just trying to identify them.... Ex. Worksheet 1 Column A B C D E F Pete Smith 8/29/2008 4 TaskA PRJ840 EN Worksheet 2 Column A B C D E F Pete Smith 8/29/2008 12 TaskA PRJ840 EN What we would like it to do..... Worksheet 3 Difference... Column A B C D E F Pete Smith 8/29/2008 8 TaskA PRJ840 EN Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to compare two worksheets and create a new worksheet | Excel Discussion (Misc queries) | |||
Compare 2 columns - new worksheets | Excel Worksheet Functions | |||
compare two columns with different ranges in two worksheets | Excel Discussion (Misc queries) | |||
how to compare columns in 4 worksheets | Excel Discussion (Misc queries) | |||
compare columns of different worksheets | Excel Discussion (Misc queries) |