Im building a company wide roster for work and I desperately need help with thee last 1/3 of the project.

Currently I have a workbook with the tables needed for the roster. I have a usreform to add data to the "Master Roster", I have the code to call data to the userform from the "Master Roster" for the search function using the tech ID#(txtID.value). Im in need of a code to then allow me to update the textboxes on my userform to the same row the search function found. And possibly an additional search code to search for techs via last name.

Any assistance would be greatly appreciated, Ive tried several different approaches and cant seem to get it right.


Master Roster.xlsm