Macro help with Userforms and separate data sheets.

Good Evening everyone.

Long story short.
I have made a UserForm in which I am able to populate the relevant data to the relevant 'Machine' data sheet
E.g. All work codes for number 1 are submitted to number 1s data sheet.

My current code finds the next empty row and populates.
I wish to change this to: finding the 4 digit work code that is entered into the Userform and populating against this number on the data sheet.
Numbers are 0000 to 9999 (in order) and are labelled as the SNOW. AC is the machine label.

I have tried a few ways through google and 'VBA for dummies' and I am yet to understand how to do it.

My current code:

Please Login or Register  to view this content.

I made this from scratch by playing around for a couple of weeks, so it may not be the easiest to read. I'm not sure I could even elaborate further on every step.

I hope I have made my question clear and the formatting is correct.
This is my first post and I'm learning as I go.

Thank you in advance

T

I'm very sorry for the late reply but I managed to finally solve my problem!

I will make sure I am ready to upload workbooks next time.
Thank you!

T