Comparing worksheets modification

[hakuna.matata]

Hello Everybody,

The macro attached with this workbook works fine. It compares the two Columns and when the IDs are matched then it puts that id to the worksheet 3 with attributes. The Problem is that if the multiple IDs exists (more than 2) and these ids are compared then they did not comes to the worksheet 3. For the sake of example workbook is attached with this thread.

[patel45]

your macro uses dictionary, then eliminates duplicates, if you don't want eliminate duplicates you have to use another type of code.
change the thread title to "Comparing worksheets with duplicates"

[hakuna.matata]

Yes you are right but it also uses sorted lists so only doubles can comes not more than doubles. Is it not possible to modify it for multiples?

[hakuna.matata]

Any solution exists.

[patel45]

it exist for sure, but you have to explain better criteria for comparison, otherwise you have to wait for the user suggested attached macro