moving duplicates to a new tab

[xxrichbxx]

I am wanting to create an archive sheet where old records (full row) needs to be added.

I have a list of invoices which can contain duplication based on a product number, the only unique reference is the date.

What I am trying to do is to move all duplicate entries with the exception of the latest version into a new tab and create an archive sheet. By doing this it will just leave the live invoice per product and therefore condensing the list significantly.

Once this is done I would like to automatically update the archive sheet by the product number then descending dates.

In my head it seems straight forward, but I haven't a clue where to start so could really do with help.

Thanks for reading.

 

[Fluff]

This can certainly be done with VBA, but we'll need some more info.
Could you supply a screen shot of how your data is now & how you'd like it to look.
Tools to do this are available here
https://www.mrexcel.com/forum/about-board/508133-attachments.html