How to Split a Spreadsheet into Multiple Sheets or Workbooks based on Column Value

Dealing with data (as in statistics, not storage) is a daily job of sysadmins. I love CSV exports but often times I need to separate the data out by a certain column or split into multiple workbooks/files to send to other staff. For instance, there are 22 branch offices where I work and getting the appropriate data to each building from one spreadsheet used to be a daunting task.

The first macro below (SplitToWorksheets)