So, my second post is a 'sequel' to my previous post
I have this user input, UserId.Text , that is being checked to see if it exists on a certain sheet.
I have a sheet named Users, with columns ID(unique), Name and Sirname.
And I have a sheet where all the 'events' should be stored.
So you fill in your ID, and hit a button.
It checks whether the ID exists in the list on the Users-sheet. If it doesn't exist there=>Exit
It it exists, it pastes the ID from the userinput to the 'events' sheet.
But now, I would like to have also the corresponding name/sirname pasted to this 'events'sheet.
So UserId is in ColumnA, Name is columnB and sirname is Column C, starting from Row 2
So let's say
<tbody>
</tbody>
So if the user-input for UserID.Text = 1, then on the 'events'sheet, it should make a new line
with
<tbody>
</tbody>
But only based on the user input.
I hope, again, my question is clear.
And I hope your answers will be as well![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
If it's desired, I will post my code, maybe it's more clear then.
Thanks in advance!
Kind regards
I have this user input, UserId.Text , that is being checked to see if it exists on a certain sheet.
I have a sheet named Users, with columns ID(unique), Name and Sirname.
And I have a sheet where all the 'events' should be stored.
So you fill in your ID, and hit a button.
It checks whether the ID exists in the list on the Users-sheet. If it doesn't exist there=>Exit
It it exists, it pastes the ID from the userinput to the 'events' sheet.
But now, I would like to have also the corresponding name/sirname pasted to this 'events'sheet.
So UserId is in ColumnA, Name is columnB and sirname is Column C, starting from Row 2
So let's say
User ID | Name | Sirname |
1 | VanAs | Karel |
2 | DenTurk | Bert |
<tbody>
</tbody>
So if the user-input for UserID.Text = 1, then on the 'events'sheet, it should make a new line
with
1 | VanAs | Karel |
<tbody>
</tbody>
But only based on the user input.
I hope, again, my question is clear.
And I hope your answers will be as well
If it's desired, I will post my code, maybe it's more clear then.
Thanks in advance!
Kind regards