Macro to Add new user in database in the same worksheet

[graiggoriz]

Hello,

I need to create a macro that would add a new user in the same worksheet "database".

In fact, as per the attachment, I already have the Name, Lastname and Email automatically filled in when selecting an existing user (from the login field).

However, I need your help to create a macro that will add a new entry in the user "database" (in fact add a row from A196 with user#, logion, firstname and lastname in the attached document). So when the login, Name and Lastname are filled in with a new user (bear in mind that in my current version I have a reset button that reinsert the formulas I put on the right side in blue) I need that user to be added in the table 1.

Please feel free to get back to me if my explanations aren't clear enough.

Thanks,
gregory

[djdjdj]

Hi,

Try this:

[graiggoriz]

It was close!! But you based the macro on the login which can be different than "USR". Is it possible take into account the numbers?

[djdjdj]

Like this maybe?

[graiggoriz]

Sorry I click before mentioning ! it was fairly easy to fix!! You solve ,my thread thanks a lot