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

Copper Contributor

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.

4 Replies
Hi,
This was very useful until the new updated office 365 which seems not to allow the formula to calculate and I have tried using the new dynamic array formulas of transpose, sort, filter, and isnumber but not working for multiple sheets or referencing other sheets!!!
Please any helpful suggestions???
I found out that I didn't need to go into the Macros section and type "application. calculate" again. Problem solved.
Cheers and thank you for always trying to help.
God Bless you.