VBA - Find differences in two columns

[mprivitt]

Hey all,

I'm new to the forums here, but I'm trying hard to get a project done and can't quite figure out how to do this macro...

Problem:

I have two excel workbooks. I want to write a macro that, once clicked, asks me which workbooks I would like to compare. Then, the macro compares column A in workbook 1 with column A in workbook 2 and highlights the numbers in workbook 2 that ARE NOT in workbook 1. The numbers are in no particular order. I merely would like to highlight the numbers in workbook 2, column A that are not in workbook 2, column A.

Help?

 

[mprivitt]

Maybe you're confused as to what my goal is. I took some screenshots to help you envision it. I have two workbooks - File1 and File2. Before executing the macro, I have the following windows open:

Then, after executing the macro and clicking "YES" (to activate File1.xlsx), the macro will execute and the windows will now look like this:

Cells A1:A6 are highlighted in File1 because they are not found in File 2 cells A1:A10.

 

[MikeDBMan]

The code is to highlight NOTHING in the workbook in which it starts. It only highlights the second file. And I just revisited the code. No way it is highlighting everything.

 

[MikeDBMan]

If you answer NO, then you get the results you just showed. I just did it and that is what I got. No sure where you're going wrong but that's a fact.