B
Bud
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
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