Hello ... I have a situation here that I will explain the best I can for what I need to have added to the existing code.
In the attached workbook, I start with Sheet2 where I have a static inventory list of stamps to be assigned to a person. In the userform, when I "Create New Employee", it searches sheet2 to make sure that the number exists. If it does, it allows the information to be added to sheet1 unless sheet1 already has the that number assigned. This all works fine...
The next part is, I move employees and numbers to sheet (historical record). On that sheet, I have the column checking for a date older than x amount of months. What I need to have is, when a new employee is created on the form, not only do I check sheet2 for existance and sheet1 for a duplicate, I need to be able to also check "Historical Record" for a duplicate in column A .... AND check column G in historical record to be sure it is older than 6 months.
What this does is, when a number is used in Sheet1 and then sent to history, the same number cannot be used again for 6 months. I hope I explained clearly as to what I need to add to this.
Bookmarks