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