Duplicated values / data

[lani_berina]

Hi everyone,


I need help on how to find duplicated values / data from the master list in col O2:O241 to sheet1 col. B1:B125, SHEET2, COL. B2:B10 and to SHEETB COL B2:B10.

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]O[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD]23232[/TD]
[TD]23233[/TD]
[TD]454545[/TD]
[TD]54545[/TD]
[/TR]
[TR]
[TD]55664[/TD]
[TD]64646[/TD]
[TD]464666[/TD]
[TD]64654[/TD]
[/TR]
[TR]
[TD]MASTER LIST[/TD]
[TD]SHEET1[/TD]
[TD]SHEET2[/TD]
[TD]SHEET3[/TD]
[/TR]
</tbody>[/TABLE]


Thank you very much in advance for the help.