alphabetical order

K

kevmo1977

I have 2 worksheets i am working with. I have them pasted together so I only have to type the information in once. The problem I am having is the first sheet is listed alphabetically by name. I want the second sheet to be alphabetically by department. When I sort the second sheet though all I get is ****required field****. What did I do wrong or what didn't I do? Please help me with this.
 
Top