Split Excel Worksheets to Individual Files

This video shows how to take an Excel workbook and break down the sheets within it to their own workbooks/individual Excel files.

Full detail on my blog here :
https://chrisbryson.wordpress.com/2013/05/21/split-excel-worksheets-to-individual-files/

VBA Script :

Sub Splitbook()
MyPath = ThisWorkbook.Path
For Each sht In ThisWorkbook.Sheets
sht.Copy
ActiveSheet.Cells.Copy
ActiveSheet.Cells.PasteSpecial Paste:=xlPasteValues
ActiveSheet.Cells.PasteSpecial Paste:=xlPasteFormats
ActiveWorkbook.SaveAs _
Filename:=MyPath & "\" & sht.Name & ".xls"
ActiveWorkbook.Close savechanges:=False
Next sht
End Sub

Video Length: 01:55
Uploaded By: Chris Bryson
View Count: 50,074

Related Software Products

Excel-Tool Split Excel Sheet

Published By:
Excel-Tool

Description:
The software can split a sheet into multiple sub sheets by the field in columns. You may have to split a very large worksheet into sub sheets by the field in columns, then the software is your right choice in simplifying your tedious splitting work. It worked smoothly and quickly, even with large worksheets, thereby saves your time. It is very simple to use.

Related Videos

How to Split the Excel 2013 Worksheet into Windows For Dummies

You can compare data from two separate sections of an Excel 2013 worksheet on your screen. Just split the worksheet into panes, it's so much easier than scrolling through a bit worksheet! hr / bClosed Caption:/b although zooming in and out on the worksheet can help you get your bearings it can't bring together two separate sections so that you can compare their data on the screen to manage this split the worksheet area into separate ...
Video Length: 02:21
Uploaded By: fordummies
View Count: 30,379

How to split the worksheet window in Excel 2010

http://www.worksmarter.tv This video shows you how you can split a worksheet window in Excel. 16 hr / bClosed Caption:/b welcome to work my TV I am i from in the studio assure you Street to watch and because sometimes you yep such other date on your school that way down decision Rafi Aquino chart kick it and an that you can see watch in a row for example is this to send in 678 no idea until you crop ...
Video Length: 02:40
Uploaded By: Maarten H
View Count: 8,490

How to split a workbook to separate Excel files?

How to split a workbook to separate Excel files. http://www.technocomsolutions.com/exc... Excel Files Splitter tool can split sheets of Excel files & create new files out of pages. It has the latest & unique features that help in splitting files easily. It supports all extensions of .xls, .xlsm, .xlsx, etc. & can process them in huge amount. The files that are created after splitting can be saved in a folder of your choice. It will works smoothly in all variants of MS ...
Video Length: 02:08
Uploaded By: Techno Com
View Count: 2,592

How to split large table data into multiple Excel Sheets on a Excel File by using SSIS Package-P169

SSIS Video Scenario: How to Export Data to Multiple Excel Sheets from Single SQL Server Table in SSIS Package which was dividing the data to multiple sheets depending upon distinct value in one of the column. In this post, we are going to split the rows without using any column value. Think about a situation where you have 3.5 million records and you would like to write 500,000 on each of the excel sheet. The package should be able to take number of ...
Video Length: 35:53
Uploaded By: TechBrothersIT
View Count: 2,231