Prevent Duplicate Row & Population of Last Scan

Hi everyone,

I'd be obliged if someone can provide some additional help with an existing macro that I was able to find online. The current macro is an inventory counting tool that verifies the barcode scanned in column J2 with the barcode in column D. If a match is found, the count in column F against that row is increased by 1. In addition to this function that the macro provides, I would like to prevent duplicate rows from being entered into the sheet as it causes issues with the count. Column B & Column C would be the only 2 columns being analyzed for duplicates (i.e. if the same part number and batch number is entered twice on the sheet, the macro will display a message and prevent the creation of that data. Identical batch numbers can exist against different part numbers and vice versa). Lastly, I'd like if the details of the row that is most currently modified (quantity increased by macro or the user in column F) to be displayed under the heading "Last Scan" (Bin, Part Number, Batch Number, Barcode and Name). I have attached a sample file with the current existing macro. Your assistance is greatly appreciated.

Thanks!