Multiple Searchable Drop Lists …ANYWHERE in the Sheet? Are you kidding me?

There are different ways to create a Single SEARCHABLE Drop Down List (a Data Validation List) in Excel…All these techniques enable you to type few characters and the content of the drop down list shrink accordingly, making it easier to find the desired option.
HOWEVER, … all the techniques allow you to create a SINGLE Data Validation list, in a Single cell.
Some time ago, I posted a Tutorial on How to create a searchable Drop-Down list in a single cell, You can watch this tutorial by clicking on the link in the description below.
   • Create a Searchable Drop Down List in...  

I then received a specific question so many times:
How can we get the same functionality in MULTIPLE cells Anywhere in the worksheet?
In this tutorial, I modify one of the 9 functions I created in the previous tutorial … I encourage you to watch that tutorial and then learn how to expand the Searchable functionality of your data validation to Multiple Cells ANYWHERE in your worksheet.
You can download the Exercise File and Follow along, by clicking on the Link here below:
https://www.amazon.ca/clouddrive/shar...
To read my Step by Step Blog articles or Register to one of my Free Webinars, visit my blogsite:
www.OfficeInstructor.com
Follow me on Facebook: www.Facebook.com/OfficeInstructor
To book a Corporate Training or take a Microsoft Office Specialist Exam, visit:
www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released…
The Best Is Yet To Come.