Hey, that depends on. From what I understand, you log in to a cell, but want the next logins to be stored, for example, in the cells below, without risk of overlapping from the previous login. Correct?
When storing the login in a cell, for example: A1 of sheet 1, the next login must be stored in A2, and the next on A3, so on.
If each login is already stored in a variable (recommend), I would do the following:
Sheets(1).Range("A1000000").End(xlUp).Offset(1, 0).Value = login
Addendum: If you want to know the date and time of login, also include this line:
Sheets(1).Range("A1000000").End(xlUp).Offset(0, 1).Value = Now()
This code gives you autonomy of up to 1 million records and I performed based on a variable called "login", but you should rename it to the variable of your code, in addition to the references. I’m sorry if I didn’t get it right, but it made sense to you?
you can post the code you have to register to make it easier for someone to help.
– R.Galamba
I believe you could create a hidden tab where you insert each record line! You check the last line and enter the user login on the next line
– Nicolas Pereira