I have data on a worksheet, alphabetized by a certain column. On another
worksheet, I would like to be able to create a drop down list to choose one
of these values. then have that value, plus other values show up on the
worksheet.

Can this be done?