Split Excel Worksheet into Separate Worksheets Based on Column Value WITHOUT VBA MACRO

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/07/Split-Data-into-Separate-Worksheets.xlsx

In this Microsoft Excel video tutorial I demonstrate how to split a worksheet into separate worksheets based on column value. For each change in column value a new worksheet is created. Without using a VBA macro, one of the quickest ways of achieving this is with a PivotTable.

#microsoftexcel