Comparing one column to another for duplicates

[cmp3182]

Hello all,

I am trying to figure out a macro that will compare one column, "H" in Sheet1, to column "A" in Sheet3. I have seen the VBA code for this a while back and can't seem to find it now. I have tried a few simple codes but it is not working for me. I have tried the code with small numbers, A1:A5, but i need it on a larger scale. Any help is greatly appreciated.

[AB33]

Why can not you Index and Match formula?

[cmp3182]

I'm still learning excel formulas and VBA. I chose VBA because I have seen the code before but do not remember what it was

[AB33]

There are many ways of comparing columns. Please attach a sample and show us the desired result.

[cmp3182]

Here is the example. I hope I explained it good enough.

[AB33]

Are you matching the master with new list or compare list? If it is new list, there is no match? What do you mean by return to new column? Which one is the new column?

[cmp3182]

comparing the master list to the compare list. if there is a number that is in the compare list that is not in the master list, then that new number is returned to an empty column "new list"

[AB33]

You can use the find and match functions which may be easier for you to understand than using a dictionary object.

[AB33]

As I said, there are dozens ways of doing the same task. This is one of them. Others may come up with a different code.

[cmp3182]

Thank you, I will try it out! I appreciate all the help!

[cmp3182]

AB33,

this is what i am looking for, however, i need it to compare one column (list1) on sheet1 with another column on another sheet2 (Master List). is that possible? I changed the names of the sheets, but nothing happened. I am not sure what I did wrong. Any help is greatly appreciated.

Thank you,
cmp3182

[AB33]

Please attach the new sample