|
|
#4
09-04-2023, 03:03 PM
|
||||
|
||||
In Excel you would add filter buttons at the top by making it a table (aka ListObject) and filter by name.
To set up a mail merge where each person gets a list of their results using this source info, you would need to set up a more complicated merge which is known as a 'Many to One' merge. This tool by Graham Mayor should provide assistance for doing that - Merge Many To One
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Convert an excel file with many fields into one with a few specific fields
|
Sportsmen | Excel | 12 | 11-19-2022 02:34 PM |
| How can I set up tab to go back and forth between legacy fields and content control fields in a Word | Ikajed | Word | 1 | 10-13-2017 06:06 PM |
|
Displaying FORMTEXT fields when merge fields are empty or null
|
sfkHooper | Mail Merge | 6 | 01-19-2016 04:24 PM |
| Macro to keep formatted form fields after mail merge or replace text with formatted form fields | jer85 | Word VBA | 2 | 04-05-2015 10:00 PM |
| Word 2010 - DOCX File with fields -> PDF with fields | senglory | Word | 2 | 03-27-2012 10:10 AM |
Windows 10 
Office 2016
Threaded Mode