Help : Search Duplicate Records and Paste to New Worksheet
 

Hello,

Need your Help.
Is there a way that you can search and if found duplicates records it will
copy
and paste records from sheet1 to Sheet2.
A macro VBA for Excel.

Sheet 1
Column A Column B
Name Address
Conde Zaldy USA
Bill William Manhattan
Conde Zaldy Chicago


Results at Sheet 2
Column A Column B
Name Address
Conde Zaldy USA
Conde Zaldy Chicago



Thanks in advance.
Zaldy