Thread: [Solved] Linking 2 lists
View Single Post
 
Old 05-24-2016, 10:21 AM
DaveCh DaveCh is offline Windows 7 64bit Office 2013
Novice
 
Join Date: May 2016
Posts: 7
DaveCh is on a distinguished road
Default Linking 2 lists

I have a worksheet with the top row showing 12 districts (1-12), and under each district column I have the name of the corresponding counties.
Now, I am making a worksheet that allows the user to select a district (1-12) which--in turn--will trigger the list of the corresponding counties for selection.

How do I do that?

I did create one unique cell on my worksheet that the user can click and pick among nearly 60 counties. I don't like this since I want my users to learn which counties are under which district, and ultimately minimize their search time.

Thanks,
Dave
Reply With Quote