Hi Bytebodger it is not my intension to insult or disrespect you but your tutorial sucks.
Why on earth would you, or anybody else, choose to enter all list items, and who knows how many lists are needed, in the same worksheet as were you are going to use the pull down lists in?
Great tutorial!! A big thumbs up for the fact that this video is also available as a step-by-step guide on your website.
You saved me time!
I would have liked it if you would have shown how to use the other functionalities of this feature as well though. But still Fantatastic and Helpfull!