Hi,
I have created a dropdown in Excel 2003 using the menu Data > Validation, Validation Criteria: Allow=List.
I'm using this dropdown to show a list of employees, which has a few thousand rows. So, obviously it's a bit painful to scroll down the list to select the employee I want.
Is there a way to enter a few characters of the name, and get a filtered set to values?
(Please note: this dropdown is one of the columns of an Excel 2003 List. As the number of rows in the list will grow dynamically, these dropdowns will need to be created for each row. So I chose to create the dropdown using Data>Validation, rather than as a combobox form control.)
Thanks,
Sam