View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Katalio Katalio is offline
external usenet poster
 
Posts: 3
Default How do I create a drop-down menu to sort data?

Hi! I use Microsoft Office 2003. A part of my job is to maintain a
spreadsheet containing data on vehicles my company owns & rents. It looks a
little something like this:

unit no. --- VIN --- plate no. --- year --- make --- model --- cost
(data goes in cells underneath column titles above)

What I want to do is have a drop-down menu that will take all that data and
allow the user to sort its order of precedence in the list by unit number, or
year, or cost, etc. How would I go about doing that?