Hello. The code I was given for my original question, still works very well. I was wondering, is there a way to add to the code the following option:

If the employee id number is not found, then add it and the other information to the list. I have a successful update code that works for me, but I am having difficulty combining it with your code. I prefer to keep your code in place and build upon it. Any suggestions on how I can take another approach. After the process of updating the record or adding a new one is complete, maybe a message, update complete, or record added can appear. Again, as always, thanks in advance for anyone?s help. 


    Set anchor_cell = Range("data").End(xlDown).Offset(1, 0)
anchor_cell.Value = Range("employeeid").Value
anchor_cell.Offset(0, 1).Value = Range("employeedept").Value