Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Split an excel file into multiple files based on a column's content Split an excel file into multiple files based on a column's content
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 07-03-2018, 10:33 PM
puff puff is offline Split an excel file into multiple files based on a column's content Windows 7 64bit Split an excel file into multiple files based on a column's content Office 2013
Advanced Beginner
Split an excel file into multiple files based on a column's content 		 
Join Date: Apr 2017
Posts: 60
puff is on a distinguished road
Question Split an excel file into multiple files based on a column's content

Hi all! I have an excel sheet that contains lots of information and I want to split it into multiple excel files based on a column called "list #". I used string from "list 1" to "list 23" to label all those rows. I know how to do the job in python but it will be messier. Is it possible to split this file into 23 files such that each smaller excel file only contain the rows with the corresponding list number? Thank you XD
Reply With Quote
  #2  
Old 07-04-2018, 08:35 AM
NoSparks NoSparks is offline Split an excel file into multiple files based on a column's content Windows 7 64bit Split an excel file into multiple files based on a column's content Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
puff / creamypuff95

Have a read of this.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Read multiple xml files in excel - Column names and Tag - Column alignment sumshen Excel Programming 0 04-17-2017 12:55 AM
Split an excel file into multiple files based on a column's content Combine Different Word files into one file and update Table of Content tejaspareek Word VBA 4 11-04-2014 05:50 AM
Split an excel file into multiple files based on a column's content Excel found unreadable content in file.xls. Do you want to recover the content of this workbook? Sanfran Excel 2 10-21-2014 12:09 AM
Split an excel file into multiple files based on a column's content Insert values from multiple rows based on value in one column pachmarhi Excel 3 07-18-2014 09:57 PM
Split an excel file into multiple files based on a column's content convert multiple csv files to multiple excel files mit Excel 1 06-14-2011 10:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:42 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft