Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-19-2017, 04:46 PM
swilfong swilfong is offline Create separate files organized by a column value Windows 10 Create separate files organized by a column value Office 2016
Novice
Create separate files organized by a column value
 
Join Date: Aug 2017
Posts: 1
swilfong is on a distinguished road
Default Create separate files organized by a column value

I have data in Excel. There are several thousand rows. One of the columns has a persons name. Each person has multiple rows of information.

I need to create either separate excel files for each person with their info or be able to merge it into a word document for them. There are a couple hundred people.

Does anyone know if this can be done? How?
Reply With Quote
  #2  
Old 08-20-2017, 03:09 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Create separate files organized by a column value Windows 7 64bit Create separate files organized by a column value Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome
at first glance MSWord Mail merge should do the job. Have a look at our Word forum and more precisely https://www.msofficeforums.com/mail-merge/
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



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
Problem create different headers using separate sections Rand Word 1 08-11-2015 12:24 PM
Create separate files organized by a column value Checking data in separate files ksigcajun Excel Programming 7 05-22-2014 08:54 AM
Create separate files organized by a column value Can I use the filter function to separate letters into separate files? drhauser Mail Merge 2 12-14-2011 02:18 PM
Any easy way to separate a Word document into separate files? SamHelm Word 0 08-21-2010 05:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:38 PM.


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