TheBigCountry
New Member
So I'm working for a company at a new job and from time to time employees will make requests for products.
I need to create an excel sheet to give to the warehouse workers to pick the order. There are over 300 SKUs at the warehouse.
My first thought was to create a VLOOKUP and use sku number in order to autofill the request sheet. But apparently, sku number isn't widely used in this company.
My second thought was to create a drop down list in Excel, but that also seems cumbersome with 300 items on it.
Therefore is there anyway to type out a list of all the items (ie Gloss - Lipstick, Shade - Lipstick, Brighten - Eyelash), in the workbook, hide it, so when I start to type in Item description field, it starts to autofill?
I need to create an excel sheet to give to the warehouse workers to pick the order. There are over 300 SKUs at the warehouse.
My first thought was to create a VLOOKUP and use sku number in order to autofill the request sheet. But apparently, sku number isn't widely used in this company.
My second thought was to create a drop down list in Excel, but that also seems cumbersome with 300 items on it.
Therefore is there anyway to type out a list of all the items (ie Gloss - Lipstick, Shade - Lipstick, Brighten - Eyelash), in the workbook, hide it, so when I start to type in Item description field, it starts to autofill?