I want to have a combobox drop down list that auto- predicts the list for any cell that I click on that has data validation. This list can be very long, so this would be helpful to shorten the search time. It would also be great to make the list font bigger and have more items fit on the list.
I was trying to follow this youtube video which pretty much has what I want (needs to be excel 2010 compatible).
https://www.youtube.com/watch?v=vOOuSe_s6pQ
I have added a template version of mine, but unsure why it is not working like it is in the video?
Thanks!
Bookmarks