excel find duplicates move to new sheet

[internero]

Hello

I am looking to achieve the following. I have attached sample files as reference. I am using excel 2010

I wish to move all duplicates from one sheet (Orders) to another(Duplicates).

Sheet0 is the original sheet(Orders)
Sheet1 is the orders sheet once the duplicates have been removed
Sheet2 is the duplicates sheet

Sheet3 I am also looking to achieve what is in sheet3 so that the quantity and stock code is all in one row as shown in the example sheet3

Basically I am looking for it to finish up like sheet1 and sheet3

I have tried searching but cannot find anything that will do this with my limited knowledge. Any help would be much appreciated

Link to files
https://www.dropbox.com/sh/01s6pln1jkhp55o/AABBWGh7_DJ1_Seu5qdsfLHqa

 

[internero]

Hi

I was just wondering if anyone had a solution to this?

 

[shahfahad]

Why not use conditional formatting and highlight all the rows that are duplicate. Use filter and sort it by color. And you can just copy all that data to another sheet and remove the filter.

 

[internero]

Hello shahfahad

Thank you for your reply. I already use this way to do this myself. I do however have a couple of people who are computer phobic and I am trying to automate the process for them with either a macro or similar if possible