Searchable Drop Down - Without VBA

Chihiro · Apr 2, 2018

Since, there is periodic request for this type of set up. For referencing purpose.

Searchable dropdown using data validation and Cell() formula, without use of VBA.

Refer to post below for original thread.
https://chandoo.org/forum/threads/data-validation-not-saving-xlsx-file-excel-2013.37149/#post-223270

kadrleyn · Jan 22, 2021

Hi,
I just used a little Vba code to sort the data when I left the sheet where the data was taken :

Code:

Private Sub Worksheet_Deactivate()
    Range("A2:C" & Rows.Count).Sort Range("A2"), xlAscending
 End Sub

I created searchable lists with dynamic name and formula .