HELP! Compare cells of a column to same column in different workbook and highlight diffs

Hi,

I am essentially a complete novice at VBA. I have used it in the past but usually only by recording a macro to do what I want, looking at the macro code and attempting to make it automated.

I am working with 2 workbooks of production order data. What I have is a file from last week and a 2nd file from this week. Completed orders will drop out of the 2nd file and I'm not concerned with those. New orders will show up in the 2nd file but there is nothing that identifies them as new orders. What I would like to do is compare each order from the 2nd file to the orders in the 1st file and change the font color of (or highlight) the entire row in the 2nd file if the order is NOT in the 1st file. These would be the new orders I want to view. I have been trying to use the .Find command but am not having any luck. Here is some sample data and the code I am tyring to create. Each order number is unique so there will not be duplicates.

Any help is greatly appreciated.

Thanks,

Bradley

P.S. - Row 1 is blank, Row 2 contains headers and Row 3 begins data
P.P.S. - I am unable to upload a file with the data and macro code, sorry.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

A simple vlookup will tell you if the data in the first file is in the second file

Data Range

	A	B	C	D	E	F	G
3	Order_Number	Due_Date	P/N	In Second W/B	Order_Number	Due_Date	P/N
4	500907482	4/18/2012	ITM003690488	No	50175100	10/23/2014	SAP000000000540183
5	500907483	4/18/2012	ITM003690488	No	50175101	11/10/2014	SAP000000000540184
6	50194300	11/10/2014	SAP000000000539503	Yes	50284344	10/28/2014	SAP000000001222638
7	500903885	4/30/2012	ITM003694834	No	50194300	11/10/2014	SAP000000000539503
8	50284344	10/28/2014	SAP000000001222638	Yes	50211316	11/10/2014	SAP000000000539479
9	50284345	10/28/2014	SAP000000001222639	Yes	50284345	10/28/2014	SAP000000001222639

In cell d4 type: =IF(ISERROR(VLOOKUP(A4,$E$4:$E$9,1,0)),"No","Yes") and copy down.

This can be automated with VBA, but what do you consider elegant? Suggest you tell us how you would like the results displayed.