Breakout Data

The idea for this one came about after spending an afternoon breaking our master table down into dozens of smaller files for distribution, and then having to redo the whole project after being told to include additional columns. 

This tool is pretty straight forward.  To use it, simply paste your data into the Data tab and click a button.  The file will read your headers and you'll be prompted to select which header you wish to breakout the data using.  Enter the corresponding column and click OK.

Let's assume you're breaking out an employee population by manager, so you'd enter the column which contains the manager ID.  You then go grab some coffee.  The file will generate a file for each manager ID and save each file onto your Desktop - they may also be saved to your Documents folder or your most recent working folder - for whatever reason, it doesn't always put the files where it's told.

The only real headache with this tool is that you still have to distribute all of the files to the appropriate manager, and this file doesn't support a unique password for each file.  This can certainly be done.  Feel free to reach out if you need additional functionality to support your needs.

breakout_data.xlsb
File Size:	34 kb
File Type:	xlsb

Download File

---