I have been searching the interwebs all day long looking for a solution. I really hope someone can assist me.
I am creating a Change Order Log for my company. What I am currently attempting to accomplish is when an employee uses the UserForm to create a new change order, the Trade Name that is selected from the Combobox on the userform will populate multiple cells on another worksheet.
For example:
The Combbox is populated by Column A in Sheet1 (trade names)
When a trade is selected and the other change order fields are completed, the employee clicks the "Create CO" button.
The information from the userform then populates sheet "Change Order Template". Cell B7 is populated with the trade name selected in the Combobox.
I need cell B8 from sheet "Change Order Template" to populate with the contact name which is located in Column B of Sheet1 based on the selection from Column A from the Combobox.
This may be extremely confusing - I can clarify if need be.