I am trying to set up a worksheet for product ordering to cut down on incorrectly ordered items.
In one tab I would like to have the database containing every item we have ever ordered with the appropriate order number.
Every time we place a new order with our supplier I would like there to be a new tab created with the order date and a new "Order Form" I would like the order form to be inteactive enough so that my staff can enter a search term (that may only match part of the product description) and have it return a list to select from or have a "find next" option so that they can select the appropriate product and have it fill in the appropriate fields.
For example... I would like my staff to be able to type in "GenOne" and have it search the database and return the product descriptions for both "GenOne 60mL" and "GenOne 120mL". They should then be able to select the correct item and have it fill in the appropriate cells containg the proper unit and order number. Idealy this search field would not have to be case sensitive.
I don't care if this is set up with a search field at the top of the screen and just have it fill the next available line on the order form or if each line has its own search command. Once I get the description field filled in, it should be a simple step to use the VLOOKUP formula to fill the other columns appropriatly.
I have done some searches and found some ideas on how to get the job done, but my knowledge is keeping me from executing the formulas/commands. I have attached a sample woorkbook so you have a general idea of what I am hoping to do. Any help would be greatly appreciated. Thank you in advance.
Sample product order worksheet.xlsx
Bookmarks