searchable dropdowns

[chris torres]

Ok So I have a two separate worksheets.

1. contains the list for my dropdowns
2. contains the dropdowns for my users to choose from

one list has 1975 names
the other has 1417 names

on the user worksheet where I user data validation to create dropdowns which contain the list from the first worksheet. I am using to columns for each of the list. each column have 200 rows when all have dropdowns I would like to make each of the cells with dropdowns searchable for the user.

 

[Macropod]

This is a duplicate of: https://www.mrexcel.com/forum/excel-questions/1022036-how-make-dropdown-searchable.html

Please read Mr Excel's policy against creating duplicate threads, in Rule 12: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Thread closed. You may continue the discussion in your other thread.