Hi jithu_ex,

Welcome to the forum!!

You could just have a VLOOKUP formula in your "Invoice Entry Daily File" file (ideally in the column next to where you're entering the invoice numbers) that looks up your entry to the "Invoice Entry Master" workbook and if found returns a message saying that invoice number has been used or no message if it hasn't been used. No need for VBA.

HTH

Robert