VBA Code to write data to sheet

Hi all,

See attached my workbook, I have a user form and when the OK button is pressed I need to get the data to write to the master sheet. Sheet1 behind.

Is there also a way I can re-populate all the data back to the userform using my search URN combo box?
then the recorded can be altered and when update is pressed on the user form the record just updates on the master and not adds another record. ive seen a few codes but they don't seem to work for me ? thanks

Thanks

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.