You mentioned that you are new to VBA, so before we work on handling duplicate entries, is there anything else that you need modified in the code or in the way that it returns. Once we are confident that the code runs as needed, we can the add code to prevent duplicate entries.