[Bonus] Split an Excel file to many sheets

Note: This is one of the many bonus lesson videos. You cannot download these videos, but you can view them anytime (they are all hosted on YouTube).

Not your usual VBA tutorial, this in-depth video shows you how to solve a practical automation problem using VBA.

Learn how to

  • Split a large, messy report format data in to multiple sheets
  • Format each sheet consistently
  • Sort the data
  • Apply conditional formatting to highlight items that have too little of margin
  • Name the worksheets consistently
  • Also learn how to code a macro that can delete all the split worksheets so you can star over.

Download the full example workbook

Click here to download the file

Watch the lesson video

More ways to split Excel data

See below pages to learn how to split data in other ways

Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.