How to create a cell drop down list. (1 Viewer)

Hi! I have vacation schedule file, on column A are names, from column B and so on are date of the month. I would like to create a drop down list on every cell to select whether a employee took a Vac, Sick, Pers, Hol, 1/2Vac, etc. When you click a cell a drop down list appears and when you made a selection, the selected item is posted on the cell. At the bottom of the date column is a formula, case sensitive, that counts total employee off for that day and only two are allow to be off on the same day.

Howdy, and welcome to the board.

Go to Data > Validation, and in the resulting dialog window, on the Settings tab, in the dropdown at the top choose "List".

Then box below, enter this (no spaces):

Vac,Sick,Pers,Hol,1/2Vac

Now if you have the list of items somewhere elsewhere in the workbook and it changes (items added), then use a dynamic named range (i.e. TimeList), then in the above put this:

=TimeList
________
One Vaporizer

Shades, very greatful, thank you, I've learn something new and it works.