Urgent help needed with VBA in excel for barcode scanner worksheet

Here is a screenshot of my current excel spreadsheet:

Orig.PNG

Here is a copy of the code I am currently using:

Please Login or Register  to view this content.

Currently the way the excel sheet works: if you enter a value into column A and it is an original piece of data, it will add a date/time stamp onto the row in column C. If you repeat that same piece of data again further down the column, it will recognize that it is a duplicate and add a "time out" in column D on the row that this same piece of data was already entered. It will also delete that whole row of the duplicate too.


WHAT I WOULD LIKE MY EXCEL SHEET TO DO:


This is how I would like my excel sheet set up:

new.PNG

Columns A and B would be data input either via keyboard or barcode scanner. Column C would be "Column A/Column B" as to make a unique number combination. Column A is employee ID number and Column B is Manufacturing Order number. The whole goal of having that Column C is so that you have a unique number tying that employee to a certain job. The main reason is that you can have several employees working on the same MO, but only one MO can be worked by any given employee at a time.

I have found what I thought to be a solution by entering an excel forumla to calculate that "Column A/Column B" but apparently excel forumlas negate the VBA code of the same cell. So I need VBA to automatically calculate column C after BOTH column A and column B have been entered, and this leading to the time stamp being placed.


Hopefully I explained this well enough, and any help would be greatly appreciated! Thanks!

Some reason that didn't work for me. Did it for you?