leverageexcel.com
  • Home
  • Tools & Training
    • Completed Projects
    • Formulas
    • Free Tools
    • How To
    • Training
  • Blog
  • Contact Us

Tips, Tools, & Tutorials

Breakout Data

7/2/2019

0 Comments

 
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

0 Comments



Leave a Reply.

    Leverage Excel

    It's about doing more... 

    Archives

    September 2019
    August 2019
    July 2019

    Categories

    All
    Completed Projects
    Formulas
    Free Tools
    How To
    Training

    RSS Feed

Site powered by Weebly. Managed by SiteGround
  • Home
  • Tools & Training
    • Completed Projects
    • Formulas
    • Free Tools
    • How To
    • Training
  • Blog
  • Contact Us