Compare 2 Workbooks and Highlight Differences

I have an excel document that I get each week with a list of all order requests from a customer.

Columns are as follows
PO#, Material, Description, Delivery Date, Qty, Customer Comment

Each week the new excel sheet may have delivery date changes or qty changes for a PO# or a line may have been deleted.

What I would like to do is have a fairly simple way to compare each sheet whether with a function or some programming that would highlight whether any cell has been changed in each row or somehow show whether a line has been deleted or added.
The problem I am having is there is no unique identifier for each row.
The PO# may be in multiple times.

Any ideas on how I could go about this? I don't know VBA that well.
I am using Excel 2007. I have another user on Excel 2003 that would benefit with a solution on this as well.

There is a similar post here, only I need to detect row deletions AND additions

Any help would be very helpful!

Regards,

LM

I guess your objective is to run a comparison to a previously backed up copy of the target workbook or to a copy of the similar workbook that you are sure it hasn't been changed.

Have you taken a look at the Track Changes feature in excel. Not quite sure when you can find it on xl07 but F1 can tell you.

Or you can look at this: http://www.ozgrid.com/VBA/track-changes.htm
or this:http://www.excelforum.com/excel-prog...worksheet.html

Remember to do a search first before posting; these guys, besides willingly trying to help you, have a job they are accountable to as well

I see! However, as far as my knowledge goes changes on a given spreadsheet (without a soft log on the same workbook) are stored inhouse, ie. on the local computer in which the changes are effected. That is the reason why you cannot Undo on a recently opened workbook, the history is cleared once the workbook is closed. I'm a real rookie in VBA, but hopefully you find help here...

However, why would it be hard that you use the above tools, save them on a workbook and you re-send them to you customers to replace their copy? So that when it returns to you (and all subsequent copies) it'll have the code or tool enabled so that you can track changes. You'll have to do something similar anyways if these guys provide you with a piece of code, which probably will be similar to the above, cause, I may be wrong, but it will be really difficult, if not impossible , to have a tool on your computer that can tell you that on a recently received file that has never been on your computer x row or y column with z cell were edited/deleted or added.... Just saying....