I'm attempting to make a drop down list that selects one particular item and
will sort the excel spreadsheet by the selection.

For example: If my list includes Fruit, Vegetables and Other, when I select
'Other' the only entries that show are 'Other'.

Any suggestions? I've scoured the Microsoft Excel help pages without any luck.