I have a worksheet with last years jobs on it:
A B C D E F G
Date Job # Salesman Client How Hours Status

I need to update the worksheet with the same data, except it's possible that
some of the information has been changed (i.e. salesman, status).

Would the best way be to combine both lists together, sort on the Job # and
just look through every two rows to see if there's a change or if the info
stayed the same or is there some kind of formula I can use that would make
this easier?

TIA for any/all help/insight!!!