top of page
Spreadsheet Splitting Automation
Project Requirement

A team spends a lot of time manually splitting and emailing spreadsheet files for distribution. They have requested a way to make the process more efficient. The distribution files must maintain the same format, formulas, and data validations as the original spreadsheet.

Project Work Done

  • I have created an Excel VBA macro that automates the process of splitting files

  • Users will be asked to select the column they want to split

  • Users can choose other options such as hiding the split column, and if/where to freeze panes

  • The split files are automatically saved in the same folder location as the original file

  • Please view the VBA source code and a working sample below

​

Source Code - Visual Basic (VBA)
Working Sample

Click the play button to watch video. You can adjust the video speed, if desired

bottom of page