Forum Discussion
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...
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???
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???
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.
- 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.