Macro to detect duplicates

Reset calls the clearing of the Range A2:E1002. After Import, your macro runs, to check if in the given range are any duplicates, to indicate that the user has selected the wrong file for import.

And instead of the user clearing the range by him or herself manually, I tried to put it in front of the MsgBox when a duplicate was detected.