Userforms - find, retrieve and update information

[JReffold]

Hi,

I'm new to this forum, but have a little knowledge of VBA/Macros. I have created a userform to enter information into an excel worksheet.

I have also created a second smaller userform to enter an ID number (which is generated when the first userform is submitted) which I now want to programme to search and find the ID and then repopulate the first userform with the information already submitted. I need to be able to amend it and then submit the form again - overwriting the existing information for that record.

I've searched numerous sites, and have tried to decipher some existing code, but I'm not winning. Any ideas? I have attached the workbook I am working on.

Many thanks in advance
Jo