Hello Everyone,
Thanks in advance for any assistance you provide!
I have attached a sample of the workbook I am working on. This is with the information cleaned up and examples shown.
If you click the "Create Work Order" button on the right side of sheet 1 (Work Order) it will pop up a user form. That works great and you don't need to worry about that.
The issue comes when trying to enter items. If you press the "Add More Items" button it brings you to a user form for entering item information.
I have a combobox set up to pull the manufacturers item # if there is a customer item number assigned to it. So, in theory the person doing the data entry will be able to type in or select the customer's item number and it will autopopulate the manufacturers number through a vlookup code. This works great if the customer item # is alpha numerical but doesn't work if the item # is a number. I have tried different formats, etc and it just won't work.
The other problem is the vlookup to autopopulate the item description won't pull at all.
This is my first project using userforms and so everything might be a little messy, and maybe I'm making a rooky mistake but I just can't figure it out.
Hopefully this is enough info with the workbook attached to get some help.
Here are the codes I have attached to my forms.
For The Manufacturers Item # to Be Autopopulated
For The Item Description to Be Autopopulated
To place the data from the form into the workbook:
To close the form and hide blank rows:
Thank you again!!
Mandy
Bookmarks