Hello

I'm using Excel 2000 and someone has asked me to set up a spreadshee
to enter personnel training records.

In some of the cells i'm wanting to give the inputter options o
picking from a list of outcomes. What is the best way to set this u
so that I can then filter out certain ones?

For example one of the columns will be whether they attended a full o
part time course. How would I set up the drop down box to give the
the option of picking full or part time and then filter out all th
full time courses.

Thanks in anticipation for any help you can give me.

Mar

--
Message posted from http://www.ExcelForum.com

Hi
see:
http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlautofilter01.html


>-----Original Message-----
>Hello
>
>I'm using Excel 2000 and someone has asked me to set up a
spreadsheet
>to enter personnel training records.
>
>In some of the cells i'm wanting to give the inputter
options of
>picking from a list of outcomes. What is the best way to
set this up
>so that I can then filter out certain ones?
>
>For example one of the columns will be whether they
attended a full or
>part time course. How would I set up the drop down box
to give them
>the option of picking full or part time and then filter
out all the
>full time courses.
>
>Thanks in anticipation for any help you can give me.
>
>Mark
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>

Thanks for the links. That's just what I was looking for.

Mar

--
Message posted from http://www.ExcelForum.com