Possible? or Not? how to make a cell autofill information from a list on another worksheet

drdre77

New Member
Joined
Dec 27, 2017
Messages
13
Hi Everyone,

I would like to know if it's possible that is, on how to make a cell autofill information from a list on another worksheet. I have a worksheet called "PRODUCT LIST", they all have a SKU (alpha numerical code) depending on the supplier.. example... one supplier, the code all starts with WNVxxxxx0 and I have about 300 products from them, then other supplier for example, ECDRxxxxx0 and the list goes on with about 5000 products and over 15 suppliers.
So this product list is on my worksheet called "PRODUCT LIST", the SKU is all in column A,
In My Invoice Sheet, I have it so that if you know the SKU, it lookup the price and enter quantity etc...

I know I can make a drop down list, but that's a big list to go through... also way too many codes for the cashier here to remember. What I would like to know if it's possible... is if the person at the counter here wants to sell a product to a customer that walked in and wants to do an invoice, in my INVOICE SHEET, where needing the SKU, if that person can start typing the SKU, and it autofills and reduces the amount of options available by matching each characters and weeding out what doesn't match.

Ex: Total products in there is about 5000 of them... But supplier WNV has 300 products, so if I start typing WNV, it would not populate the other 4700 products because they don't start with that. and so on....

Hopefully I explained it properly.... Hopefully it's possible.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
You could make a dependent data validation list. So you would pick the supplier and then the SKU data validation drop down would only so the SKUs for that supplier.

for more info on dependent data validation see
http://www.contextures.com/xlDataVal02.html
 
Upvote 0

Forum statistics

Threads
1,223,909
Messages
6,175,312
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top