If you have a list of attendance violations, you can use an AutoFilter
to add a dropdown list to each column heading.

There are AutoFilter instruction in Excel's help, and he

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

David Bateman wrote:
They are on a spread sheet and we have probably 1100 attendance violations
per month. Is it possible to have a list box at the top of each column? One
column each for name, Date, time, violation, and have them populate down the
sheet to the first blank cell at the bottom of each column?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html