Copy Rows With Duplicate Detials Into Another Sheet

[MrMann35]

Hi all,
I need a macro that will copy the entire row of a sheet to another sheet if the information in column E is duplicated anywhere else in column E. I've tried to find one on here but can only find macros which will delete the whole row, which is not good for me as i need the duplicates to be identified. I also tried making one myself but could only get it to copy one of the duplicate rows to the other sheet, which is no good for me as I need both instances where there is a duplicate to be identified.

Any help much appreciated.

[mike7952]

If you can upload your workbook it would be better for us to help you

[MrMann35]

Here it is.
I need it to check for duplicates in column E on the details tab and place duplicates in the duplicates tab.

[mike7952]

I only see hearders?? No header for column E. Are there only 5 columns?

[MrMann35]

Yes I had to delete the data as its confidential. Column e is acc no and sort code combined. I need to check this for duplicates. Only 5 columns yes.

[mike7952]

You have a formula in column E in your example is that how you real workbook is?

[MrMann35]

Yes that joins account details and sort code together so you only need check one column for duplicates

[mike7952]

Give this a shot

Please Login or Register  to view this content.

[MrMann35]

Works a charm.
Thanks whoever you are.

[abousetta]

@MrMann35, if your problem is resolved then please mark the thread as solved. Also you can thank @mike7952 by clicking on the star below his posts.

Good luck.

abousetta