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.