Hold Tag Auto Populate

[Kuro Kuma22]

Hello Everyone,

I'm creating a Hold Log for the company I work for and I want to make it fairly simply for our quality techs to fill out the information needed to put things on Hold. There are two tabs on the spreadsheet. One tab is fairly basic, they input the data of the Hold/Rework. This tab is used to input any and all relevant information:

The second tab is the Hold/Rework Tag itself:

My goal here is to have them enter all of the information for the Hold on the first tab and then on the second tab all they have to do is enter the Hold Tag Number and it auto populates all of the information in all of the other sections. How would I code this?

 

[Kuro Kuma22]

Where... on the "Hold Tag" sheet? If so, why? Your concept of filling everything in on the "Hold Info" sheet and using the "Hold Tag" sheet as a viewer seems straightforward enough to me.

The fields meant to have auto complete enabled are on the Hold Info sheet. When it comes to entering in the product selection we have over 1,800 products to choose from and I'd like for them to be able to start typing the information in based on a list and it starts to auto complete so that they don't have to scroll through the entire list.

 

[Kuro Kuma22]

So the code works quite well as long as the information is in the first row of the hold info sheet, and this is probably my mistake for not having more details, but ideally the code needs to search down column A on the Hold info sheet for the matching text entered into the C1 space of the Hold Tag Sheet and then populate with the info that's in the row where that number is found.