Compare lists and extract differences

[ejoneslor]

I have piece of code in a workbook that brings in new data to a worksheet and then performs some actions to create a report on a different sheet. Each time the spreadsheet opens the data refreshes and may or may not bring in new data.

I need to compare the two lists and update my report using only new values.

In the attached example I need to compare the list in 'Master' to the list in 'dB Dump'. It should result in the answer in 'New Refs'. I only care if the are in 'dB dump' and not in 'Master', I do not care of there are references in 'Master' that are not in 'dB dump'. I hope that makes sense.

Would anybody have an idea of how to code this in VBA?

Any and all help appreciated.

Ed

[Gatti]

Hello!

Try this:

Please Login or Register  to view this content.

[rxk]

I am just new to VBA/macro and I am looking of a code similar to this.
I tried the above code but it only copied all entries on Master worksheet to New Refs worksheet. I am not sure if I do it right.

[stnkynts]

Here you go ejon

Please Login or Register  to view this content.

@Gatti. Your code is sound except for you were returning positive results rather than the ones that weren't found in RangeDump. This can be easily corrected by removing the "Not" in this line

Please Login or Register  to view this content.

@rxk. Start a new thread with your question. PM me the link and I will look at it.

[jindon]

Try

Please Login or Register  to view this content.

[jindon]

In case of a huge data.

Please Login or Register  to view this content.

[ejoneslor]

Thank you all for responding. I managed to get Gatti's method to work with a little tweak to clear previous results on each refresh.

Ed