Download the featured file or copy the code from here: https://www.bluepecantraining.com/wp-content/uploads/2023/07/Split-Data-Into-Separate-Workbooks-VBA.zip

In this Microsoft Excel video tutorial I demonstrate my VBA macro that will split data, currently held in a single worksheet, across multiple worksheets based on a column value. You can download the feature file or copy the code by visiting the page linked to above.

00:00 Introduction
00:18 See the macro in action
01:38 Walk through of the VBA macro code
06:40 Assign a button (on the Ribbon) to run the macro