Auto Filter lists

[Mark W]

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

 

[Frank Kabel]

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

 

[Mark W]

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

Mar