#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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 |
|
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 |
Checking data in separate files | ksigcajun | Excel Programming | 7 | 05-22-2014 08:54 AM |
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 |