Thread: Drop Down List
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Otero Tim Otero is offline
external usenet poster
 
Posts: 20
Default Drop Down List

Hi Craig,

There are several different ways to do this. One is with Data
Validation. Debra Dagleish is the expert on that you can get more info he

http://www.contextures.com/xlDataVal01.html

For other ways, I have an example spreadsheet I put together a while
back. I put it online for you, he

http://public.sheet.zoho.com/publish...changing-lists

HTH
tim


CraigMacE wrote:
I have one sheet for data entry where entries include names and dates among
other things. I want to create a second sheet that will search through the
first list and list and return a list with only the date selected in a
drop-down list. An individual could then select a date and see all entries
with that date.

My main objective is to have entries sorted by date and I would consider
another idea if it would accomplish the same task of creating a list of all
entries with a specific date. I do not want all entries sorted in
chronological order in the same sheet.