I have names in sheet 2 and would like for those names to appear on sheet 1 as per needs basis. What I mean by per needs basis is I want to be able to type the first letters of the last name and then have all the names that beginw tiht that letter show up in that cell so that I can choose the right student.
This should help.
Here's a technique for using a single cell to first select a sub list of names, then use the same cell again to select final option.The sample file on that page helps demonstrate the technique: AutoCompleteDataValidation(SortOf).xls
Last edited by JBeaucaire; 12-27-2019 at 10:10 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks