HI,

It's great that you figured it out. But, let me ask you a question.
Does your program look at each row ( same row in each sheet) to see if there is a difference between sheet 1 and 2.
And, if a row in sheet1 does not match sheet2 your code will place a "V" in sheet1 to say there is a difference between sheet1 and 2 for the same row?
Your code will then populate sheet2 column "G" CONCATENATE "A" thru "F". Which will then go to sheet1 at the point where sheet1 does not have a "V".
Is this basically what your code does?