Forum Discussion

Copper Contributor

Dec 06, 2019

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

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 th...

Stockdatabase.xlsx54 KB

excel

SergeiBaklan

Diamond Contributor

Dec 06, 2019

Sivahari

The idea is, for example, here https://www.pk-anexcelexpert.com/searchable-drop-down-list/

ituryu
Brass Contributor
Jul 21, 2021
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???
- SergeiBaklan
  Diamond Contributor
  Jul 22, 2021
  ituryu
  
  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.
  - ituryu
    Brass Contributor
    Jul 23, 2021
    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.