Forum Discussion
Solved
Autocomplete in a data validation cell
Using Office 365 Excel in Win10 desktop Made a form with a data validation column for products from a separate sheet in my workbook Watched the Contextures.com video to make it possible to autocomp...
See the attached version. I simplified the code.
If you attach a copy of your workbook, someone may be able to help you.
Also, I usually use Access for this type of stuff, but in this case it has to be Excel because others will need to be able use it on their phones and that's not an option with Access. Quickbooks Online is useless for this type of business, so that' why I am trying to figure this out in Excel