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.
Bookmarks