Hello Experts,
Please help to form the macro.

--> I am having Sheet1 and Sheet2 in the same workbook.
--> I want to compare Column B of both the sheets.
--> If duplicate found, then the corresponding row to be deleted from Sheet 1

Thank you in advance.