Drop Down List
 

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.

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.

Drop Down List
 

Craig:

This link is better:

http://share.zoho.com/preview/sheet/249557000000005001

Sorry about that...first time using this

Tim Otero wrote:
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.