Hi! I am not an expert and these forums really helped me a lot when I make projects (copy paste it and just hope that it will work! lol) Anyway, I have a new project where employees need to log in and out of the workbook with their own log ins and passwords where I just used the MATCH formula for so that can access the hidden sheets that are only allowed for their own access. However, I need to create something for them to do a password reset. I don't want them to always give me their passwords as it is weird and would take so much of my time. So what I did was I created a sheet for them to place their new password ("PASSWORD CHANGE" sheet) then I created another sheet where their passwords are stored ("PASSWORD LIST" sheet) which only has A column - Employee Number and B column - their passwords. If the employee puts the password that they want on the PASSWORD CHANGE sheet, they just have to click a button and the macro will automatically copy the new password and paste it on the PASSWORD LIST sheet beside their respective employee number. Easy to explain how it should work but I don't know if this is possible. Thanks in advance for your help!!!
Bookmarks