Dec 06 2019 08:05 AM
Hi Experts,
I want to access the master database using “Item Code” in Daily Stock Movement Register Sheet. I have used the basic drop-down list using data validation function but due to length of the list, it is getting annoyed to choose the right product.
I saw some experts’ opinion in the web but it is useful for a sheet where we stored the database.
Advance thanking you for your opinion.
Dec 06 2019 09:50 AM
The idea is, for example, here https://www.pk-anexcelexpert.com/searchable-drop-down-list/
Jul 21 2021 02:31 PM
Jul 22 2021 02:20 AM
The idea is here (2) Searchable Drop Down List in Excel (Very Easy with FILTER Function) - YouTube, not sure what could be wrong with reference on another sheet.
Jul 23 2021 10:46 AM