I have an employee schedule that I need to total the hours for each individual employee on a seperate sheet. The employees names are in column A and some employees are listed more than once. I have the employees total hours in the w column. I am needing to total the hours of each employee and combine the hours of the employees that are listed more than once. Also if possible I would like to sort the list by name.

Thank you,

Duane