title: Creating a separate excel file for each filter result
body: <p>I have a spreadsheet which I want to split to separate spreadsheets for each department there are more then the departments shown and I want the .xls files for each to be save with the department name</p>
  
  <p>The department field is column D.</p>
  
  <p>i.e. I would like an .xls file for each with only the records for department 1, department 2, and so on.</p>
  
  <p>Unfortunately I am unable to post a screenshot of the spreadsheet as my rep isn't good enough yet.</p>
  
  <p>What VBA code would I use to do this?</p>