How can I active a row from a listbox in a user form?

Hello
I am an amateur at this stuff, so any help is greatly appreciated.
I currenly have a user form that enters some basic information into the next empty row in my worksheet. I now need to create a second form to be used later in the process, adding additional information. I'd like to have people be able to pick a job number from a listbox in the new form, and have that activate the row that the original information is stored. The listbox would be populated by the data in the column of the sheet containing the job number. This way, when the folks identify which job they are working on, the rest of the data being entered from the second form will be placed into the correct row. Once again, any help is greatly needed and appreciated.

Hi Magma,

I am like you. Searching for the same like you do. Maybe we can work together?

Greetings

Bastian

Hi Bastian
Not sure how much I can contribute. My company is too small to have any IT support, so if I want to collect data, I'm on my own. Unfortunately, all of my knowledge has been self taught, and not knowing the subject matter makes that a difficult task. If I have any breakthroughs or suggestions, I'll send them your way to see what you think.

John

Hi Norie
I have attached the workbook as requested with a couple of lines of sample data. The information in red is what needs to activate the row for the balance of the data to be entered, and is the information currently populating the listbox in the second user form, the assembly labor entry form. Thanks in advance for your help.

Norie
That works really well. I did come across one problem, and I'm sure it is because i didn't explain myself as well as I should have. Entering data into a row is not a one time shot, other people will be making entries into the same row at a later date. Unfortunately, when I try to do this, it erases any previous data. Is there a way to keep what was entered, while adding new information?
Thanks for getting me this far!

I worked on this over the weekend and had no luck. Which of the 2 options mentioned would be the easier route? I wasn't sure what sort of changes would be needed to enter the data to the sheet using the second method.

Thanks for everything, it is up and running just the way I needed it to be. I appreciate all of your help!