Macro for copying/pasting rows based off duplicated columns

[dexceler]

Hello All,

I have been attempting to find a macro that will look for duplicates in columns A and then copy the entire row for those entries into another spreadsheet. I have searched through the forum of past questions and nothing quite captures what I am looking to do.

Can the geniuses of MrExcel help me?

Example Below)
sheet1

Column A Column B Column C Column D Column E
Name DOB Arrival Date Departure Date Time Spent

Joe Smith Aug 9 1987 Aug 12 2015 Aug 15 2015 3
Jack Arm Aug 1 1992 Dec 1 2015 Dec 12 2015 11
Joe Smith Aug 9 1987 Aug 20 2015 Sep 2 13


So ideally, the macro would find entries 1 and 3 and copy the entire row into sheet2.

 

[dexceler]

Here is a better example of my scenario

[/IMG]