Hello everyone,

I have a dataset with a long list of Rows, with Column headers that contains ID numbers and some ‘other information’. I currently have a UserForm created that has text boxes which ask the User to input the ID number they are looking for, and the ‘other information’ they would like to update into the dataset. What I would like help on is the code for the command button that would find the ID number under the column header, and to automatically transfer the ‘other information’ the user inputted into the same row (the one that matches the ID number).

I currently have a rough start; my code only transfers the UserForm inputs into the next empty rows.

Please Login or Register  to view this content.

I would like my code to transfer the UserForm inputs into the column that match another ID that is in the existing row.

Any help would be greatly appreciated!