I have following requirement.
I have excel sheet with UserName. I have to take input from user for UserName. If the name exist in the excel sheet then it will log the status in another sheet with success. If the name don’t exist, it will log the status as Failed in another sheet. For Failed attempts, it should allow to enter the name for three times, and then it should give the status as locked. Please find the excel sheet.
Login Tab has UserName
Login Attempts has login Status…
Login Attempts worksheet should be blank in the begining. once any body try to input Username, it should append the following details.
We don’t have access to Active directory, hence we have to work this way for few months.
Failed_Login_Attempt_Spreadsheet.xlsx (13.8 KB)