Absence Sheet

[Dishboy09]

Needing assistance with creating my absence sheet.

I am needing the dropdown/type cells and hours cells to calculate into other columns.

Row A = Type with dropdown for types of absences vaca/sick/military
Row B = # hours absence
Row C = Sum of hours of certain type from dropdown vaca/sick/military

Any help?

 

[Logit]

.
For the drop down lists :

The first section "Creating Data Validation (Manually)" located at this URL : http://software-solutions-online.com/excel-vba-drop-down-lists/