Comparing 2 worksheets

[KristieKMD]

Hi everyone,

Couple of months ago, I asked help here and was able to solve my problem. This is the link: http://www.excelforum.com/excel-form...96#post2847496

Sample of working file using Arlette's code: "Sept Sample 1.xlsx"

Anyway, everything was working fine until last week, I found a few duplicates in the data that was being compared and with thousands of rows, it's hard to do it manually. So my question is, is there a way to compare 2 columns instead? It would probably have to use Arlette's code since that one has the "first six, last 4" thingy (as shown on sample 1 above) and then additional code to counter-match it with another column.

Sample file with new columns: "Sept Sample 2.xlsx" with columns H and I from sheet 1 to be compared to E and F from sheet 2.

As always, any help is greatly appreciated

[arlu1201]

So which columns do you need to be matched?

[KristieKMD]

Hi again Arlette

It's H and I from sheet 1 to be matched to E and F from sheet 2 on the Sample 2 file.

[mike7952]

Give this a try

Please Login or Register  to view this content.

[KristieKMD]

Works like a charm!

Thank you sir, thank you!

[mike7952]

Your welcome.