Tweak Macro to find Matches instead of unique use dictionary

The Macro finds all the unique values in column B of sheet("YYY") that are NOT in coluwn A of sheet("XXX").

Is there a way to alter it so that it finds all the matches between these two columns?

I know there are otherways to do this but I was hoping to do this with Dictionay method

Thank you

Please Login or Register  to view this content.

thanks Sixthsence I will give it a try

if you really do want a dictionary approach, you could consider the following
on a new sheet, put a few values in columnA and a few values in ColumnB, with several values common to both columns
then run the below macro.
if it does produce the kind of result that you want, it's easily modified to columns on different sheets as your opening post seems to request

Please Login or Register  to view this content.