Macro for copying/pasting rows based off duplicated columns

dexceler

New Member
Joined
Jun 14, 2015
Messages
14
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.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Here is a better example of my scenario
2v3j56t.png
[/IMG]
 
Upvote 0

Forum statistics

Threads
1,226,695
Messages
6,192,478
Members
453,727
Latest member
tuong_ng89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top