Macro to compare worksheets, highlight change

Closed
kcj784 Posts 1 Registration date Wednesday September 19, 2012 Status Member Last seen September 20, 2012 - Sep 20, 2012 at 09:46 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 21, 2012 at 07:07 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Sep 21, 2012 at 07:07 PM
Could you post a sample book with sample data at some public file share site and post back link back here
0