I am creating a user form to track training at work for multiple
employees.

I created a userform to enter the data and figured out how to enter
that data into a spreadsheet by creating a submit button.
Here's where I need help.....
I want to be able to lookup by employee ID#, using a search button on
the userform that will allow it to autofill all of the information
back onto the userform so I can make updates and or changes to an
individuals training dates or classes or whatever the specific data
is. Then to be a bigger pain in the butt. I want to be able to hit
"submit" on the userform and have the info on the spreadsheet updated
with the new info.

Can anybody help? I taught myself all of the stuff I have done so
far
but, I am totally stuck.

If anybody is willing to help I would greatly appreciate it.