try the new macros. What to do with the entries in column F after deleting the duplicates? I would suggest to flag them so they don't get copied again or delete them also.
I would suggest to join the transfer of the duplicates to sheet2 and the deletion of duplicates buttons into 1
Bookmarks