Macro to compare worksheets, highlight change

[Closed]
Report
Posts
1
Registration date
Wednesday September 19, 2012
Status
Member
Last seen
September 20, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,


I'm trying to create a macro that compares two excel worksheets and highlights the rows that are different. Basically, there is a sheet with rows of information. The first 3 columns contain various text that unique to that row of data. There could be a unique identifier for a row in all 3 columns or only one. The rest of the rows contain various info. Each day a report is run generating another sheet. Sometimes there are only one or two new rows of information. Let's say worksheet1 is the older sheet. I want to use search worksheet2 to see if it contains unique identifiers found in worksheet1. If it is found, move on to the next row. If it isn't found, that means the row of data is new and should be highlighted. Am I overlooking a simple way to do this? Thanks.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you post a sample book with sample data at some public file share site and post back link back here