How to Split Each Excel Sheet Into a Separate File
In this video, I will show you how to split each worksheet in Excel into a separate Excel file/workbook.
Below is the VBA code used in the video:
'Code Created by Sumit Bansal from TrumpExcel.com
Sub SplitEachWorksheet()
Dim FPath As String
FPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each ws In ThisWorkbook.Sheets
ws.Copy
Application.ActiveWorkbook.SaveAs Filename:=FPath & "\" & ws.Name & ".xlsx"
Application.ActiveWorkbook.Close False
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
To use this code, you need to save the Excel workbook (from which you want to split the worksheets) in the same folder where you want the individual files.
This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Видео How to Split Each Excel Sheet Into a Separate File канала TrumpExcel
Below is the VBA code used in the video:
'Code Created by Sumit Bansal from TrumpExcel.com
Sub SplitEachWorksheet()
Dim FPath As String
FPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each ws In ThisWorkbook.Sheets
ws.Copy
Application.ActiveWorkbook.SaveAs Filename:=FPath & "\" & ws.Name & ".xlsx"
Application.ActiveWorkbook.Close False
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
To use this code, you need to save the Excel workbook (from which you want to split the worksheets) in the same folder where you want the individual files.
This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Видео How to Split Each Excel Sheet Into a Separate File канала TrumpExcel
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Excel - Split Master Spreadsheet Into Multiple Sheets With one click without VBA](https://i.ytimg.com/vi/YERSf6DDt8w/default.jpg)
![COMBINE Multiple Excel WORKBOOKS into One | ExcelJunction.com](https://i.ytimg.com/vi/JiAYngRcN0s/default.jpg)
![VBA: Split data into Separate Workbooks](https://i.ytimg.com/vi/48oUxaL7X6c/default.jpg)
![How To Split Excel Sheets Into Separate Files | Session 6](https://i.ytimg.com/vi/uDUVeDpL8lk/default.jpg)
![Rename All Sheets From A List... In One Step](https://i.ytimg.com/vi/wv0NW9dMOfM/default.jpg)
![How to Split Each Excel Sheet into Separate Files Easy (Excel 2003-2016)](https://i.ytimg.com/vi/tt71SL2hmhM/default.jpg)
![View Two Sheets Side-by-Side in the Same Excel File](https://i.ytimg.com/vi/Hx6aFo7okCc/default.jpg)
![](https://i.ytimg.com/vi/TQuA60mF16w/default.jpg)
![10 Amazing (Less Known) Excel Tricks You Should Know](https://i.ytimg.com/vi/KdTSjdUSANw/default.jpg)
![Consolidate & Clean Multiple Excel Sheets in One Pivot Table](https://i.ytimg.com/vi/FI4HkCzMaIk/default.jpg)
![Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)](https://i.ytimg.com/vi/fHFUh6EhBcw/default.jpg)
![Excel Tutorial - Using the Split Option to See Your Data](https://i.ytimg.com/vi/D83H0HHvfMI/default.jpg)
![How to split an Excel file into multiple files using VBA](https://i.ytimg.com/vi/VSV79U8Ao-I/default.jpg)
![How to Compare Two Excel Sheets (and find the differences)](https://i.ytimg.com/vi/8Ou_wfzcKKk/default.jpg)
![The Easy Way to Create Sheets from a List of Values in Excel](https://i.ytimg.com/vi/Gdw78SR1eKo/default.jpg)
![How to Hide Worksheets in Excel (that can not be unhidden easily)](https://i.ytimg.com/vi/2bN6yZjMDNc/default.jpg)
![How to Use Power Automate to Send Emails from Excel with PERSONAL Attachments](https://i.ytimg.com/vi/ku0NM9jhp-A/default.jpg)
![Send Multiple Emails Automatically to Customers with File attachments via EXCEL & OUTLOOK. VBA MACRO](https://i.ytimg.com/vi/-bbEAIp_2d4/default.jpg)
![How to Lock Cells in Excel](https://i.ytimg.com/vi/VMaoPtVcPhk/default.jpg)
![Lookup & Return Multiple Values in One Cell in Excel (Easy Formula)](https://i.ytimg.com/vi/Tsn0y65HEAE/default.jpg)