View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bud Bud is offline
external usenet poster
 
Posts: 61
Default 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