Searchable Drop-down list for multiple cells sourcing from another worksheet in Excel.

%3CLINGO-SUB%20id%3D%22lingo-sub-1053017%22%20slang%3D%22en-US%22%3ESearchable%20Drop-down%20list%20for%20multiple%20cells%20sourcing%20from%20another%20worksheet%20in%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1053017%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%2C%3C%2FP%3E%3CP%3EI%20want%20to%20access%20the%20master%20database%20using%20%E2%80%9C%3CSTRONG%3EItem%20Code%3C%2FSTRONG%3E%E2%80%9D%20in%20%3CSTRONG%3EDaily%20Stock%20Movement%20Register%3C%2FSTRONG%3E%20Sheet.%20I%20have%20used%20the%20basic%20drop-down%20list%20using%20data%20validation%20function%20but%20due%20to%20length%20of%20the%20list%2C%20it%20is%20getting%20annoyed%20to%20choose%20the%20right%20product.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20saw%20some%20experts%E2%80%99%20opinion%20in%20the%20web%20but%20it%20is%20useful%20for%20a%20sheet%20where%20we%20stored%20the%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdvance%20thanking%20you%20for%20your%20opinion.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1053017%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1053204%22%20slang%3D%22en-US%22%3ERe%3A%20Searchable%20Drop-down%20list%20for%20multiple%20cells%20sourcing%20from%20another%20worksheet%20in%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1053204%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F480235%22%20target%3D%22_blank%22%3E%40Sivahari%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20idea%20is%2C%20for%20example%2C%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.pk-anexcelexpert.com%2Fsearchable-drop-down-list%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.pk-anexcelexpert.com%2Fsearchable-drop-down-list%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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.

1 Reply