I inherited a workbook with drop down lists but they're set up to take every
entry in a column, then sort by 'all', 'sort ascending', 'sort descending',
then all of the entries. When you click one of the entries, it takes you to
that entry cell and displays the entire line. If it's an entry that has been
used multiple times, like the sentence 'Process with normal benefits' used in
6 different cells in a single column, and it pulls all 6 lines, combining
them into one search.

This is brilliant, I love it! I just can't figure out how to set up my own
column with a drop down like that. Someone help, please?