The code seems to work, however I already have some Worksheet_Change code on that worksheet. When I add the code to the bottom of it, it doesn't work, it only works if I remove the other code. This is the code I already have:
Another issue is that I have some code which is run by the button Duplicate Data. Since the user will be entering a large amount of serial numbers at a given time (sometimes around 20-40) and usually they will either all be Receiving or Returning, it allows the user to just say select Return in the first record entered then select that cell and hit Duplicate Data to copy it to all the rows below that they just entered serial numbers into. The problem I have is that when data is entered into E that way the code doesn't work (it only works when manually entered one at a time). This is the Duplicate Data code I'm using:
Also the message box code for "serial number not found" can be removed. If there is no match then nothing should happen.
Thank you for your time,
James
Bookmarks