Split Data into Multiple Files (Workbooks) in Excel VBA | Vivekananda Sinha | Video 156

Split Data into Multiple Files (Workbooks) in Excel VBA
In one of my previous videos, I have shown you how to split data into multiple sheets in Excel. Based on the tutorial, I received many requests to create a tutorial on how to do the same task for multiple workbooks instead of multiple sheets. Splitting data into multiple workbooks is quite a time-taking and cumbersome because there is no direct option in Excel to do this. In this tutorial, I will show you a simple and awesome VBA code that will split data from one sheet to multiple Excel files. This will be based on a value of a specific column. Here, I have taken an example of employee data, where we are going to create department-wise Excel files based on a department column in the employee data. This will blow your mind. The code is written will work across all versions of Excel. Be it Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, or Excel 365.
★ My Excel Bundle Course ► futureinhands....
⯆ Download the file here: futureinhands....
★Link to Video 155: • Excel Advanced Filter ...
In this Excel tutorial we cover a few essential topics rather quickly:
How to define object variable
How to save files using VBA
How to use Advanced Filter in VBA
How to add workbook in VBA
How to add a sheet in VBA
How to use While Loop
How to split data into multiple workbooks
How to disable all alerts
How to disable screen updating
★ MUSIC IN THIS VIDEO
Music by / ikson
★ Let’s connect on social:
Our Telegram Group: fih.one/club
My LinkedIn Profile: fih.one/vs-linkedin
My Facebook Profile: fih.one/vs-facebook
Our LinkedIn Page: fih.one/linkedin
Our Facebook Page: fih.one/facebook
#FutureInHands #VivekanandaSinha #MicrosoftExcel #MicrosoftOffice #ExcelVBA