Hi,
Okay so I have a spreadsheet of employee data that includes names, hire dates, salaries and departments. What I want to do is have other spreadsheets within the workbook that have that data sorted by department/hire date as well as alphabetized.

For example

Name Hire Date Salary Department
John Doe September 5, 2002 75000 Finance
Jane Doe August 9, 2011 53000 HR
Leanne Keys October 12, 2003 33400 Finance
Melanie Marshall January 6, 2004 56700 Marketing
Pete Grant April 30, 2012 100000 HR

sorted into departments so it would look like this
Finance
John Doe September 5, 2002 75000 Finance
Leanne Keys October 12, 2003 33400 Finance

HR
Jane Doe August 9, 2011 53000 HR
Pete Grant April 30, 2012 100000 HR

Marketing
Melanie Marshall January 6, 2004 56700 Marketing



Thanks!!!